BeginVegan

Tables (9)

Bookmark

  • member_email — VARCHAR(50) — Foreign key → Member.member_email — NOT NULL
  • restaurant_no — INT — Foreign key → Restaurant.restaurant_no — NOT NULL

Member

  • member_email — VARCHAR(50) — Primary key — NOT NULL
  • member_name — VARCHAR(50)
  • member_point — INT
  • member_role — VARCHAR(50)

Menu

  • menu_no — INT — Primary key — NOT NULL
  • restaurant_no — INT — Foreign key → Restaurant.restaurant_no — NOT NULL
  • menu_name — VARCHAR(100) — NOT NULL
  • menu_price — INT — NOT NULL
  • menu_category — VARCHAR(100) — NOT NULL
  • menu_detail — VARCHAR(500)
  • menu_photo_dir — VARCHAR(500)

Payment

  • imp_uid — VARCHAR(50) — Primary key — NOT NULL
  • member_email — VARCHAR(50) — Foreign key → Member.member_email — NOT NULL
  • reservation_no — INT — Foreign key → Reservation.reservation_no — NOT NULL
  • payment_time — DATETIME — NOT NULL
  • payment_price — INT — NOT NULL
  • payment_status — VARCHAR(50) — NOT NULL

Point

  • member_email — VARCHAR(50) — Foreign key → Member.member_email — NOT NULL
  • point_div — VARCHAR(20) — NOT NULL
  • point_time — DATETIME — NOT NULL
  • point_change — INT — NOT NULL
  • point_result — INT — NOT NULL

Reservation

  • reservation_no — INT — Primary key — NOT NULL
  • member_email — VARCHAR(50) — Foreign key → Member.member_email — NOT NULL
  • restaurant_no — INT — Foreign key → Restaurant.restaurant_no — NOT NULL
  • reservation_time — DATETIME — NOT NULL
  • reservation_visit_time — DATETIME — NOT NULL
  • reservation_type — VARCHAR(50) — NOT NULL
  • reservation_people — INT — NOT NULL
  • reservation_discount — INT — NOT NULL
  • reservation_total_price — INT — NOT NULL
  • reservation_status — VARCHAR(50) — NOT NULL

Reservation_Menu

  • reservation_no — INT — Foreign key → Reservation.reservation_no — NOT NULL
  • menu_no — INT — Foreign key → Menu.menu_no — NOT NULL
  • reservation_menu_count — INT

Restaurant

  • restaurant_no — INT — Primary key — NOT NULL
  • restaurant_name — VARCHAR(50) — NOT NULL
  • restaurant_address — VARCHAR(500) — NOT NULL
  • restaurant_address_gu — VARCHAR(100)
  • restaurant_x — DOUBLE — NOT NULL
  • restaurant_y — DOUBLE — NOT NULL
  • restaurant_open — TIME
  • restaurant_close — TIME
  • restaurant_phone — VARCHAR(50)
  • restaurant_detail — VARCHAR(1000)
  • restaurant_avg_price — INT
  • restaurant_table — INT — NOT NULL
  • restaurant_table_member — INT — NOT NULL
  • restaurant_vegan_level — INT — NOT NULL
  • restaurant_photo_dir — VARCHAR(500)
  • restaurant_star — DOUBLE — NOT NULL

Review

  • review_no — INT — Primary key — NOT NULL
  • reservation_no — INT — Foreign key → Reservation.reservation_no — NOT NULL
  • restaurant_no — INT — Foreign key → Restaurant.restaurant_no — NOT NULL
  • member_email — VARCHAR(50) — Foreign key → Member.member_email — NOT NULL
  • review_star — INT — NOT NULL
  • review_content — VARCHAR(1000)
  • review_time — DATETIME — NOT NULL
  • review_photo_dir — VARCHAR(500)