trip

Tables (5)

Board

  • bno — int — Primary key — NOT NULL
  • mno — int — Foreign key → Member.mno — NOT NULL
  • titile (title) — char
  • writer — char
  • contents — varchar
  • ip — char
  • regdate — date
  • hits — int
  • filepath — varchar
  • recom — char
  • categorg — char

Event

  • Key (eno) — int — Primary key — NOT NULL
  • mno — int — Foreign key → Member.mno — NOT NULL
  • eveh — int
  • evecev (evec) — int
  • Field (eid) — char

Member

  • mno — int — Primary key — NOT NULL
  • id — char
  • pw — char
  • name — char
  • birth — date
  • mp — char
  • email — varchar
  • regdate — date

Recom

  • bno — int — Foreign key → Board.bno — NOT NULL
  • mno — int — Foreign key → Board.mno — NOT NULL
  • rwriter — char
  • rid — char

Reply

  • rno — int — Primary key — NOT NULL
  • bno — int — Foreign key → Board.bno — NOT NULL
  • mno — int — Foreign key → Board.mno — NOT NULL
  • rid — char
  • rpw — char
  • rcontents — varchar
  • rreg — date