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