ㅁㄴㅇㄹ

Tables (5)

TB_BOARD

  • POST_NO — NUMBER(10) — Primary key — NOT NULL — 게시글
  • USER_ID — VARCHAR2(100) — NOT NULL — 작성자
  • POST_TITLE — VARCHAR2(128) — NOT NULL — 게시글
  • POST_CONTENT — VARCHAR2(4000) — NOT NULL — 게시글
  • POST_DATE — DATE — NOT NULL — 게시글
  • POST_HIT — NUMBER(10) — NOT NULL — 조회수
  • POST_LIKES — NUMBER(10) — NOT NULL — 좋아요

TB_B_COMMENT

  • COMMENT — ADD — NOT NULL — DD CONSTRAINT PK_TB_B_COMMENT PRIMARY KEY (COMMENT_NO);_NO NUMBER(10) NOT NULL POST_NO NUMBER(10) NOT NUL
  • USER_ID — VARCHAR2(100) — NOT NULL — 댓글
  • COMMENT — ON — NOT NULL — N COLUMN TB_USER.USER_ID IS '회원 식별자';_CONTENT VARCHAR2(400) NOT NULL COMMENT ON COLUMN TB_USER.USER_PW IS '비밀번호';_DATE…

TB_NICKNAME_CHANGE

  • CHANGE_ID — NUMBER(10) — Primary key — NOT NULL — 변경
  • USER_ID — VARCHAR2(100) — NOT NULL — 회원
  • OLD_NICKNAME — VARCHAR2(32) — NOT NULL — 이전
  • NEW_NICKNAME — VARCHAR2(32) — NOT NULL — 새
  • CHANGE_DATE — DATE — NOT NULL — 변경

TB_POST_LIKE

  • LIKE_ID — NUMBER(10) — NOT NULL — LIKE_ID
  • USER_ID — VARCHAR2(100) — NOT NULL — 회원
  • POST_NO — NUMBER(10) — NOT NULL — 게시글
  • LIKE_DATE — DATE — NOT NULL — 좋아요

TB_USER

  • USER_ID — VARCHAR2(100) — Primary key — NOT NULL — 회원
  • USER_PW — VARCHAR2(256) — NOT NULL — 비밀번호
  • USER_NICKNAME — VARCHAR2(32) — NOT NULL — 회원
  • USER_EMAIL — VARCHAR2(128) — NOT NULL — 회원
  • USER_LEVEL — NUMBER(2) — NOT NULL — 회원
  • USER_ROLE — NUMBER(2) — NOT NULL — 회원
  • USER_JOIN_DATE — DATE — NOT NULL — 회원
  • USER_NICKNAME_COLOR — VARCHAR2(7) — 프리미엄