Triple_Review
Tables (5)
File_Info
- fl_id — varchar(300) — Primary key — NOT NULL
- type_id — varchar(300)
- origin_name — varchar(260)
- save_path — varchar(260)
Place
- place_id — varchar(300) — Primary key — NOT NULL
- address — varchar(200)
- place_name — varchar(100)
- rate — int
Review
- review_id — varchar(300) — Primary key — NOT NULL
- place_id — varchar(300) — Foreign key → Place.place_id — NOT NULL
- user_idx — varchar(300) — Foreign key → User.user_idx — NOT NULL
- content — varchar(500)
- rate — int
- reg_date — date
- mod_date — date
- r_type — char
- is_first — char
Review_History
- rh_id — varchar(300) — Primary key — NOT NULL
- user_idx — varchar(300) — Foreign key → User.user_idx — NOT NULL
- review_id — varchar(300) — Foreign key → Review.review_id — NOT NULL
User
- user_idx — varchar(300) — Primary key — NOT NULL
- id — varchar(30)
- password — varchar(60)
- email — varchar(50)
- nickname — varchar(30)
- gender — char
- join_date — date
- user_name — varchar(30)
- address — varchar(200)
- is_leave — char
- leave_date — date
- point — int