codeDrawer
Tables (6)
TB_CATEGORY (분류)
- CATE_ID (분류_고유번호) — LONG — Primary key — NOT NULL
- MEM_ID (회원_고유번호) — LONG — Foreign key → TB_MEMBER.MEM_ID — NOT NULL
- PRNT_CID (부모_분류_고유번호) — LONG — Foreign key → TB_CATEGORY.CATE_ID — NOT NULL
- NAME (분류이름) — VARCHAR(50)
- REG_DT (생성일시) — TIMESTAMP
- UPDT_DT (수정일시) — TIMESTAMP
TB_COMMENT (댓글)
- CMMT_ID (댓글_고유번호) — LONG — Primary key — NOT NULL
- POST_ID (포스트_고유번호) — LONG — Foreign key → TB_POST.POST_ID — NOT NULL
- PRNT_ID (부모댓글_고유번호) — LONG
- CNTNS (내용) — VARCHAR2
- MEM_ID (회원_고유번호)
- REG_DT (등록일시) — TIMESTAMP
- UPDT_DT (수정일시) — TIMESTAMP
TB_MEMBER (회원)
- MEM_ID (회원_고유번호) — LONG — Primary key — NOT NULL
- NAME (이름) — VARCHAR2
- EMAIL (이메일) — VARCHAR2
- PASSWORD (패스워드) — VARCHAR2
- JOIN_DT (가입일시) — TIMESTAMP
- LAST_DT (마지막접속일시) — TIMESTAMP
TB_MEMBER_ROLE (회원권힌)
- SEQ (seq) — LONG
- ROLE_TYPE (Field) — STRING
- MEM_ID (회원_고유번호) — LONG — Foreign key → TB_MEMBER.MEM_ID — NOT NULL
TB_POST (포스트)
- POST_ID (포스트_고유번호) — LONG — Primary key — NOT NULL
- CATE_ID (분류_고유번호) — LONG — Foreign key → TB_CATEGORY.CATE_ID — NOT NULL
- NAME (제목) — VARCHAR2
- CNTNS_TYPE (컨텐츠타입) — VARCHAR2
- CODE_CNTNS (코드내용) — CLOB
- CODE_DESC (설명) — CLOB
- OPEN_YN (공개여부) — BOOLEAN
- READ_CNT (조회수) — INTEGER
- LIKE_CNT (추천수) — INTEGER
- REG_DT (등록일시) — TIMESTAMP
- UPDT_DT (수정일시) — TIMPSTAMP
TB_POST_LOCKER (보관함)
- LOCK_ID (고유번호) — LONG — Primary key — NOT NULL
- POSTS (게시글고유번호리스트) — VARCHAR2
- MEM_ID (회원_고유번호) — LONG — Foreign key → TB_MEMBER.MEM_ID — NOT NULL