semi

Tables (3)

board (Untitled)

  • bd_no — number — Primary key — NOT NULL
  • id — varchar2 — Foreign key → member.id — NOT NULL
  • bd_title — varchar2
  • bd_content — clob
  • bd_date — timestamp

comments (Untitled2)

  • cm_no — number — Primary key — NOT NULL
  • cm_prnt_seq — number — Foreign key → board.bd_no — NOT NULL
  • cm_writer — varchar2 — Foreign key → board.id — NOT NULL
  • cm_content — varchar2
  • cm_date — timestamp

member (Untitled3)

  • id — varchar2 — Primary key — NOT NULL
  • pw — varchar
  • name — varchar2
  • phone — number
  • email — varchar2
  • zipcode — number
  • address — varchar2