CAKE
Tables (16)
Alarm (Untitled16)
- alarm_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → USER.user_id — NOT NULL
- content (Field) — NOT NULL
- Field2
CAKE (Untitled4)
- cake_id (Key) — Primary key — NOT NULL
- name (Field)
- description (Field2)
- price (Field3)
- image_url (Field4)
- is_same_day (Field5) — c
- created_at (Field6)
- scrap_count (Field7)
- shop_id (Key2) — Foreign key → CAKESHOP.shop_id — NOT NULL
CAKESHOP (Untitled2)
- shop_id (Key) — Primary key — NOT NULL
- name (Field)
- longitude (Field2)
- latitude (Field3)
- contatct (Field4)
- created_at (Field5)
- scrap_count (Field6)
CakeCategory (Untitled10)
- catetory_id (Key) — reserve_date — Primary key — NOT NULL
- name (Field) — NOT NULL
- cake_id (Key2) — Foreign key → CAKE.cake_id — NOT NULL
CakeLog (Untitled12)
- cakelog_id (Key) — reserve_date — Primary key — NOT NULL
- created_at (Field) — NOT NULL
- thumnail_image (Field2) — NOT NULL
- scrap_count (Field3) — reserve_date — NOT NULL
- content (Field4) — NOT NULL
- Field5
- user_id (Key2) — Foreign key → USER.user_id — NOT NULL
- shop_id (Key3) — Foreign key → CAKESHOP.shop_id — NOT NULL
CakeLogImage (Untitled13)
- image_id (Key) — Primary key — NOT NULL
- image_url (Field) — NOT NULL
- Field2
- cakelog_id (Key2) — reserve_date — Foreign key → CakeLog.cakelog_id — NOT NULL
CakeOption (Untitled8)
- option_id (Key) — int — Primary key — NOT NULL
- name (Field) — string — NOT NULL
- price (Field2) — int — NOT NULL
- created_at (Field3) — datetime — NOT NULL
- option_type_id (Key2) — Foreign key → CakeOptionType.option_type_id — NOT NULL
- shop_id (Key3) — Foreign key → CAKESHOP.shop_id — NOT NULL
CakeOptionType (Untitled7)
- option_type_id (Key) — Primary key — NOT NULL
- name (Field) — NOT NULL
- Field2
CakeReservationOption (Untitled9)
- reservation_option_id (Key) — reserve_date — Primary key — NOT NULL
- reservation_id (Field) — reserve_date — NOT NULL
- option_id (Field2) — reserve_date — NOT NULL
- price (Field3) — reserve_date — NOT NULL
- Field4
- reserve_id (Key2) — Foreign key → Reservation.reserve_id — NOT NULL
- option_id (Key3) — int — Foreign key → CakeOption.option_id — NOT NULL
CakeScrap (Untitled15)
- scrap_id (Key) — Primary key — NOT NULL
- cake_id (Key2) — Foreign key → CAKE.cake_id — NOT NULL
- user_id (Key3) — Foreign key → USER.user_id — NOT NULL
DesignCategory (Untitled11)
- desing_id (Key) — Primary key — NOT NULL
- name (Field) — NOT NULL
- cake_id (Key2) — Foreign key → CAKE.cake_id — NOT NULL
LogScrap (Untitled14)
- log_scrap_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → USER.user_id — NOT NULL
- cakelog_id (Key3) — reserve_date — Foreign key → CakeLog.cakelog_id — NOT NULL
OPERATINGHOURS (Untitled3)
- operation_id (Key) — Primary key — NOT NULL
- day (Field)
- open_time (Field2)
- close_time (Field3)
- created_at (Field4)
- shop_id (Key2) — Foreign key → CAKESHOP.shop_id — NOT NULL
Reservation (Untitled6)
- reserve_id (Key) — Primary key — NOT NULL
- reserve_date (Field) — NOT NULL
- total_price (Field2) — reserve_date — NOT NULL
- status (Field3) — NOT NULL
- user_id (Key2) — Foreign key → USER.user_id — NOT NULL
- shop_id (Key3) — Foreign key → CAKESHOP.shop_id — NOT NULL
- cake_id (Key4) — Foreign key → CAKE.cake_id — NOT NULL
SHOP_SCRAP (Untitled5)
- scrap_id (Key) — Primary key — NOT NULL
- created_at (Field) — NOT NULL
- Field2
- shop_id (Key2) — Foreign key → CAKESHOP.shop_id — NOT NULL
- user_id (Key3) — Foreign key → USER.user_id — NOT NULL
USER (Untitled)
- user_id (Key) — Primary key — NOT NULL
- email (Field) — unique — NOT NULL
- password (Field2) — NOT NULL
- name (Field3) — NOT NULL
- created_at (Field4) — NOT NULL
- Field5