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)

search_history (검색 히스토리)

    search_result (검색 결과)

      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 (웨이팅)

        waiting_history (웨이팅 히스토리)