hiio420_memo

Tables (3)

CM_CODE (공통코드)

  • cd_id — varchar(20) — Primary key
  • cd_grp_id — varchar(20) — Foreign key → CM_CODE_GRP.cd_grp_id — NOT NULL
  • cd_nm — varchar(20)
  • order_no — int
  • reg_dt — datetime
  • reg_id — varchar(20)
  • updt_dt — datetime
  • updt_id — varchar(20)

CM_CODE_GRP (공통코드그룹)

  • cd_grp_id — varchar(20) — Primary key — NOT NULL
  • cd_grp_cd (cd_grp_nm) — varchar(20)
  • order_no — int
  • comment (commet) — varchar(100)
  • reg_dt (red_dt) — datetime
  • reg_id — varchar(20)
  • updt_dt — datetime
  • updt_id — varchar(20)

Untitled

  • cd_id — varchar(20) — Foreign key → CM_CODE.cd_id