members

Tables (3)

MEMBERS

  • MEMBER_ID — NUMBER — Primary key
  • NAME — VARCHAR2(100) — NOT NULL
  • EMAIL — VARCHAR2(100) — NOT NULL
  • PASSWORD — VARCHAR2(100) — NOT NULL
  • CREATED_AT — DATE

board

  • num — number(5) — Primary key
  • memberNo (writer) — number(5) — Foreign key → member.memberNo
  • title — varchar2(60)
  • content — VARCHAR2(600)
  • regtime — varchar2(20)
  • hits — NUMBER(10)

member

  • memberNo — number(5) — Primary key
  • joinDate — date
  • name — varchar2(20)
  • id — varchar2(20)
  • pw — varchar2(20)