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