p-erd

Tables (4)

BBS_BULLETIN (게시판)

  • BBS_ID (게시판ID) — INTEGER — Primary key — NOT NULL
  • USER_ID (사용자아이디) — VARCHAR(20) — Foreign key → SYS_USER.USER_ID — NOT NULL
  • BBS_CODE (게시판분류Code) — VARCHAR(20)
  • TITLE (게시글 제목) — VARCHAR(20)
  • CONTENT (게시글 본문) — VARCHAR(20)
  • Field

BBS_BULLETINREPLY (게시판 댓글)

  • REPLY_ID (댓글ID) — VARCHAR — Primary key — NOT NULL
  • BBS_ID (게시판ID) — INTEGER — Foreign key → BBS_BULLETIN.BBS_ID — NOT NULL
  • USER_ID (사용자아이디) — VARCHAR(20) — Foreign key → SYS_USER.USER_ID — NOT NULL
  • PARENT_REPLY_ID (상위댓글ID) — VARCHAR
  • CONTENT (댓글내용) — VARCHAR
  • DELETED_AT (삭제여부) — VARCHAR(1)

SYS_COMMON_CODE (공통코드)

  • ID (아이디) — VARCHAR(32) — Primary key — NOT NULL
  • CODE (코드) — VARCHAR(20) — Primary key — NOT NULL
  • CODE_NAME (코드명) — VARCHAR(20)
  • GROUP_CODE (그룹코드) — VARCHAR(20)
  • GROUP_CODE_NAME (그룹코드명) — VARCHAR(20)
  • USE_YN (사용여부) — VARCHAR(1)
  • ORDER_NO (정렬순서) — Integer
  • Field
  • Field2
  • Field3
  • Field4
  • Field5

SYS_USER (사용자)

  • USER_ID (사용자아이디) — VARCHAR(20) — Primary key — NOT NULL
  • EMAIL (사용자이메일) — VARCHAR(100) — NOT NULL
  • USER_NAME (사용자명) — VARCHAR(20)
  • USER_PASSWORD (사용자비밀번호) — VARCHAR(256)
  • PASSWORD_UPDATED_AT (비밀번호업데이트일자) — Date
  • PASSWORD_FAIL_COUNT (비밀번호실패횟수) — Integer
  • REMARK (비고) — VARCHAR(100)
  • USE_YN (사용여부) — VARCHAR(1)