DB물리
테이블 (3)
BOARD
- BOARD_NO — NUMBER — 기본 키 — NOT NULL
- BOARD_TITLE — VARCHAR2(100) — NOT NULL
- BOARD_CONTENT — VARCHAR2(200) — NOT NULL
- USERID — VARCHAR2(20) — NOT NULL
- BOARD_CDATE — TIMESTAMP — NOT NULL
- REPLY_COUNT — NUMBER — NOT NULL
MEMBER
- USERID — VARCHAR2(20) — 기본 키 — NOT NULL
- PASSWORD — VARCHAR2(20) — NOT NULL
- USERNAME — VARCHAR2(20) — NOT NULL
- NICKNAME — VARCHAR2(20) — NOT NULL
- GENDER — VARCHAR2(20) — NOT NULL
- AGE — NUMBER — NOT NULL
- SKIN_TYPE — VARCHAR2(50) — NOT NULL
- SKIN_TROUBLE — VARCHAR2(50) — NOT NULL
- EMAIL — VARCHAR2(20) — NOT NULL
- PHONE — VARCHAR2(20) — NOT NULL
- ADDRESS — VARCHAR2(50) — NOT NULL
- MDATE — DATE — NOT NULL
REPLY
- REPLY_NO — NUMBER — 기본 키 — NOT NULL
- REPLY_BNO — NUMBER — NOT NULL
- REPLY_TITLE — VARCHAR2(100) — NOT NULL
- REPLY_CONTENT — VARCHAR2(200) — NOT NULL
- REPLY_ADMINID — VARCHAR2(20) — NOT NULL
- REPLY_CDATE — TIMESTAMP — NOT NULL