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