테이블 만들기

즐겨찾기 링크 정보를 담는 테이블 및 관련 테이블 생성

stm_link_dev (개발 링크 정보)

CREATE TABLE public.stm_link_dev (
    link_id serial4 NOT NULL,
    link_cd varchar(16) NOT NULL DEFAULT 'tech_blog',
    link_uri varchar(1024) NOT NULL,
    link_title varchar(256) NOT NULL,
    link_desc text,
    created_at timestamp NOT NULL DEFAULT now(),
    CONSTRAINT stm_link_dev_pk PRIMARY KEY (link_id)
);

-- Column comments

COMMENT ON COLUMN public.stm_link_dev.link_id IS '아이디';
COMMENT ON COLUMN public.stm_link_dev.link_cd IS '링크구분코드';
COMMENT ON COLUMN public.stm_link_dev.link_uri IS '링크주소';
COMMENT ON COLUMN public.stm_link_dev.link_title IS '링크제목';
COMMENT ON COLUMN public.stm_link_dev.link_desc IS '링크상세정보';
COMMENT ON COLUMN public.stm_link_dev.created_at IS '생성일';

---

stm_cd (공통그룹코드)

CREATE TABLE public.stm_cd_grp (
    grp_id varchar(16) NOT NULL,
    grp_nm varchar(256) NOT NULL,
    use_yn boolean NOT NULL DEFAULT true,
    created_at timestamp NOT NULL DEFAULT now(),
    CONSTRAINT stm_cd_grp_pk PRIMARY KEY (grp_id)
);

-- Column comments

COMMENT ON COLUMN public.stm_cd_grp.grp_id IS '그룹아이디';
COMMENT ON COLUMN public.stm_cd_grp.grp_nm IS '그룹명';
COMMENT ON COLUMN public.stm_cd_grp.use_yn IS '사용여부';
COMMENT ON COLUMN public.stm_cd_grp.created_at IS '생성일';

---

stm_cd (공통코드)

CREATE TABLE public.stm_cd (
    grp_id varchar(16) NOT NULL,
    cd_id varchar(16) NOT NULL,
    cd_nm varchar(256) NOT NULL,
    orders int2 NOT NULL DEFAULT 1,
    use_yn boolean NOT NULL DEFAULT true,
    created_at timestamp NOT NULL DEFAULT now(),
    CONSTRAINT stm_cd_pk PRIMARY KEY (grp_id,cd_id)
);

-- Column comments

COMMENT ON COLUMN public.stm_cd.grp_id IS '그룹아이디';
COMMENT ON COLUMN public.stm_cd.cd_id IS '코드아이디';
COMMENT ON COLUMN public.stm_cd.cd_nm IS '코드명';
COMMENT ON COLUMN public.stm_cd.orders IS '정렬순서';
COMMENT ON COLUMN public.stm_cd.use_yn IS '사용여부';
COMMENT ON COLUMN public.stm_cd.created_at IS '생성일';

코드 설정

테이블에 데이터 담기 (노가다)

맺음말

맘먹고 하면 1시간 정도면 대충 정리가 완료 되는데 ... 그 맘을 먹고 GO 하는 것이 쉽지만 않다.