team3 final project
Tables (10)
amenities (편의시설)
- amenities_idx (Key) — int — Primary key — NOT NULL
- restraunt_idx (primary key) — int — Foreign key → restraunt.restraunt_idx — NOT NULL
- has_parking (Field) — char(1)
- parking_info (Field2) — varchar(200)
- no_deposit (Field3) — char(1)
- deposit_info (Field4) — varchar(200)
- has_group_seat (Field5) — char(1)
- group_seat_info (Field6) — varchar(200)
- has_coronation (Field7) — char(1)
- coronation_info (Field8) — varchar(200)
- has_corkage (Field9) — char(1)
- corkage_info (Field10) — varchar(200)
- has_kids_zone (Field11) — char(1)
- kids_zone_info (Field12) — varchar(200)
- has_wifi (Field13) — char(1)
- wifi_info (Field14) — varchar(200)
- has_waiting_area (Field15) — char(1)
- wating_area_info (Field16) — varchar(200)
category (카테고리)
- category_idx (primary key) — int — Primary key — NOT NULL
- restraunt_idx (foreign key) — int — Foreign key → restraunt.restraunt_idx — NOT NULL
- category_address (Field1) — varchar(50)
- caregory_name (Field2) — varchar(50)
- category_tag (Field3) — varchar(100)
menu (메뉴)
- menu_idx (primary key) — int — Primary key — NOT NULL
- restraunt_idx (foreign key) — int — Foreign key → restraunt.restraunt_idx — NOT NULL
- menu_name (Field2) — varchar(20)
- menu_price (Field) — int
- menu_explanation (Field3) — varchar(200)
- menu_image (Field4) — varchar(200)
restraunt (식당)
- restraunt_idx (primary key) — int — Primary key — NOT NULL
- restraunt_addr (Field) — varchar(50)
- restraunt_call (Field2) — varchar(20)
- restraunt_hour (Field3) — varchar(20)
- restraunt_latitude (Field4) — double
- restraunt_longitude (Field5) — double
- restraunt_price_range (Field6) — varchar(50)
- restraunt_introduce (Field7) — varchar(500)
- restraunt_image_1 (Field8) — varchar(100)
- restraunt_image_2 (Field9) — varchar(100)
- restraunt_image_3 (Field10) — varchar(100)
review (리뷰)
- review_idx (primary key) — int — Primary key — NOT NULL
- user_idx (foreign key) — int — Foreign key → user.user_idx — NOT NULL
- menu_idx (foreign key2) — int — Foreign key → menu.menu_idx — NOT NULL
- restraunt_idx (foreign key3) — int — Foreign key → menu.restraunt_idx — NOT NULL
- is_one_pick (Field) — char(1)
- review_raiting (Field2) — double
- review_content (Field3) — varchar(200)
- review_write_date (Field4) — varchar(200)
- review_visited_date (Field5) — varchar(200)
- review_image_1 (Field6) — varchar(200)
- review_image_2 (Field7) — varchar(200)
- review_image_3 (Field8) — varchar(200)
user (유저)
- user_idx (primary key) — int — Primary key — NOT NULL
- user_id (Field) — varchar(20)
- user_pass (Field2) — varchar(20)
- user_nick (Field3) — varchar(20)
- user_gender (Field4) — varchar(1)
- user_age (Field5) — int
- user_call (Field6) — varchar(20)
- user_email (Field7) — varchar(20)
- user_level (Field8) — int
- user_tag (Field9) — varchar(100)
waiting_history (웨이팅 히스토리)