NTour

Tables (4)

Board

  • POST-ID — VARCHAR — Primary key — NOT NULL
  • ID — VARCHAR — Foreign key → Member.ID — NOT NULL
  • TITLE — VARCHAR
  • PDATE — DATE
  • CONTENT — VARCHAR
  • LIKE — INT

Member

  • ID — VARCHAR — Primary key — NOT NULL
  • PASSWORD — VARCHAR
  • NAME — VARCHAR
  • BIRTH — DATE
  • GENDER — VARCHAR
  • EMAIL — VARCHAR
  • PHONE — VARCHAR
  • ADDR — VARCHAR2

Photo

  • PHOTONO — INT — Primary key — NOT NULL
  • ID — VARCHAR — Foreign key → Member.ID — NOT NULL
  • POST-ID — VARCHAR — Foreign key → Board.POST-ID — NOT NULL
  • ID (ID2) — VARCHAR — Foreign key → Board.ID — NOT NULL

REPLY

  • Key (REPLYID) — VARCHAR — Primary key — NOT NULL
  • ID — VARCHAR — Foreign key → Member.ID — NOT NULL
  • Field (POST-ID) — VARCHAR
  • Field (RPLIKE) — INT