tour
Tables (4)
Hotplace
- no — int — Primary key — NOT NULL
- title — varchar(20) — NOT NULL
- content — varchar(200) — NOT NULL
- hit — int
- time — date_time
- comment — varchar(200)
- photo — varchar(200)
- writer — varchar(20) — Foreign key → User.id — NOT NULL
Notice
- no — int — Primary key — NOT NULL
- title — varchar(20) — NOT NULL
- content — varchar(200) — NOT NULL
- hit — int
- time — date_time
- comment — varchar(200)
- writer — varchar(20) — Foreign key → User.id — NOT NULL
Tips
- no — int — Primary key — NOT NULL
- title — varchar(20) — NOT NULL
- content — varchar(200) — NOT NULL
- hit — int
- time — date_time
- comment — varchar(200)
- writer — varchar(20) — Foreign key → User.id — NOT NULL
User
- id — varchar(20) — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
- email_id — varchar(20) — NOT NULL
- email_domain — varchar(20) — NOT NULL
- phone — varchar(20) — NOT NULL
- password — varchar(20) — NOT NULL