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