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