new ERD
Tables (3)
TBL_MEMBER
- USERID (Key) — VARCHAR2(50) — Primary key — NOT NULL
- USERPW — VARCHAR2(50) — NOT NULL
- USERNAME — VARCHAR2(50) — NOT NULL
- EMAIL — VARCHAR2(100)
- REGDATE — TIMESTAMP
- UPDATEDATE — TIMESTAMP
tbl_board
- BNO — NUMBER — Primary key — NOT NULL
- TITLE — VARCHAR2(200) — NOT NULL
- CONTENT — VARCHAR2(4000)
- USERID — VARCHAR2(50)
- REGDATE — TIMESTAMP
- VIEWCNT — NUMBER
- USERID (Key) — VARCHAR2(50) — Foreign key → TBL_MEMBER.USERID — NOT NULL
tbl_comment
- cno — number — Primary key — NOT NULL
- bno — number
- userid — varchar2(50)
- content — varchar2(100) — NOT NULL
- regdate — timestamp
- BNO — NUMBER — Foreign key → tbl_board.BNO — NOT NULL
- USERID (Key) — VARCHAR2(50) — Foreign key → TBL_MEMBER.USERID — NOT NULL