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)