board

Tables (3)

BOARD (게시판)

  • BOARD_SEQ_NO (게시판아이디) — int — Primary key — NOT NULL
  • TITLE (제목) — varchar(250)
  • CONTENTS (내용) — varchar(4000)
  • CLICK_CNT (조회수) — int
  • REG_DTIME (생성일) — timestamp
  • REGR (생성자) — varchar(100)
  • MOD_DTIME (수정일) — timestamp
  • MODR (수정자) — varchar(100)
  • USE_YN (사용여부) — char(1)
  • USER_SEQ_NO (사용자일련번호) — int — Foreign key → USER.USER_SEQ_NO — NOT NULL

COMM_CODE (공통코드)

  • Key (공통코드아이디) — Primary key — NOT NULL
  • UPR_CD (상위코드) — varchar(20)
  • COMM_CD_DEPTH (공통코드 뎁스) — int
  • COMM_CD_SORT (공통코드 정렬) — int
  • COMM_CD (공통코드) — varchar(6)
  • COMM_CD_NM (공통고드이름) — varchar(100)
  • COMM_CD_DESC (공통코드설명) — varchar(200)
  • REG_DTIME (생성일) — timestamp
  • REGR (생성자) — varchar(20)
  • MOD_DTIME (수정일) — timestamp
  • MODR (수정자) — varchar(20)

USER (사용자)

  • USER_SEQ_NO (사용자일련번호) — int — Primary key — NOT NULL
  • USER_ID (사용자아이디) — varchar(100) — NOT NULL
  • ROLE_CD (사용자권한) — varchar(6) — NOT NULL — GIN IDX
  • EMAIL (이메일주소) — varchar(500) — NOT NULL — UNQUE
  • USE_YN (사용여부) — char(1) — NOT NULL
  • REG_DTIME (생성일) — timestamp — NOT NULL
  • MOD_DTIME (수정일) — timestamp — NOT NULL
  • REGR (생성자) — varchar(100)
  • MODR (수정자) — varchar(100)