ㅁㄴㅇㄹ
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) — 프리미엄