O!Mykase
Tables (8)
Admin
- admin_id (Key) — Long — Primary key — NOT NULL
- store_id (Key2) — Long — Foreign key → Store.store_id — NOT NULL
- id (Field) — String
- password (Field2) — String
Booking
- book_id (Key) — Long — Primary key — NOT NULL
- menu_id (Key2) — Long — Foreign key → Menu.menu_id — NOT NULL
- store_id (Key22) — Long — Foreign key → Menu.store_id — NOT NULL
- date (Field) — LocalDate
- time (Field2) — LocalTime
- name (Field3) — String
- phone (Field4) — String
- customer_count (Field5) — int
Location_Tag
- location_id (Key) — Long — Primary key — NOT NULL
- name (Field) — String
Menu
- menu_id (Key) — Long — Primary key — NOT NULL
- store_id (Key2) — Long — Foreign key → Store.store_id — NOT NULL
- name (Field) — String
- price (Field2) — Long
- menu_count (Field3) — int
Review
- review_id (Key) — Long — Primary key — NOT NULL
- store_id (Key2) — Long — Foreign key → Store.store_id — NOT NULL
- location_id (Key22) — Long — Foreign key → Store.location_id — NOT NULL
- customer_name (Field4) — String
- content (Field) — String
- visited_date (Field3) — LocalDate
- ratings (Field2) — float
- image_url (Field5) — String
Store
- store_id (Key) — Long — Primary key — NOT NULL
- location_id (Key2) — Long — Foreign key → Location_Tag.location_id — NOT NULL
- name (Field) — String
- image_url (Field2) — String
- rating_avg (Field3) — float
- lunch_price (Field4) — String
- dinner_price (Field5) — String
- address (Field6) — String
- telephone (Field7) — String
- closed_day (Field8) — String
- business_hours (Field9) — String
Store_Tag
- store_id (Key3) — Long — Foreign key → Store.store_id — NOT NULL
- tag_id (Key4) — Long — Foreign key → Tag.tag_id — NOT NULL
Tag
- tag_id (Key) — Long — Primary key — NOT NULL
- name (Field) — String