D102_bbanggu_erd

Tables (12)

bakery

  • bakery_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.user_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(1500)
  • business_registration_number — VARCHAR(50) — NOT NULL
  • address_road — VARCHAR(255) — NOT NULL
  • address_detail — VARCHAR(150) — NOT NULL
  • photo_url — VARCHAR(255)
  • latitude — DOUBLE — NOT NULL
  • longitude — DOUBLE — NOT NULL
  • created_at — TIMESTAMP
  • deleted_at — TIMESTAMP
  • update_at — TIMESTAMP
  • updated_at — DATETIME(6)
  • INDEX — `user_id`

bakery_pickup_timetable

  • bakery_pickup_timetable_id — INT — Primary key — NOT NULL
  • bakery_id — INT — Foreign key → bakery.bakery_id — NOT NULL
  • day_of_week — ENUM('Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday') — NOT NULL
  • start_time — TIME — NOT NULL
  • end_time — TIME — NOT NULL
  • INDEX — `bakery_id`

bread

  • bread_id — INT — Primary key — NOT NULL
  • bakery_id — INT — Foreign key → bakery.bakery_id — NOT NULL
  • bread_category_id — INT — Foreign key → bread_category.bread_category_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • price — INT — NOT NULL
  • bread_image_url — VARCHAR(255)
  • created_at — TIMESTAMP
  • deleted_at — TIMESTAMP
  • INDEX — `bakery_id`
  • INDEX — `bread_ibfk_2_idx`

bread_category

  • bread_category_id — INT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • weight — INT — NOT NULL

bread_package

  • bread_package_id — INT — Primary key — NOT NULL
  • bakery_id — INT — Foreign key → bakery.bakery_id — NOT NULL
  • price — INT — NOT NULL
  • discount_rate — FLOAT — NOT NULL
  • quantity — INT — NOT NULL
  • created_at — TIMESTAMP
  • deleted_at — TIMESTAMP
  • name — VARCHAR(100)
  • description — VARCHAR(500)
  • pending — INT — NOT NULL
  • INDEX — `package_ibfk_1`

echo_saving

  • echo_saving_id — BIGINT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.user_id — NOT NULL
  • saved_money — INT — NOT NULL
  • reduced_co2e — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — `echo_saving_fk1_idx`

favorite

  • favorite_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.user_id — NOT NULL
  • bakery_id — INT — Foreign key → bakery.bakery_id — NOT NULL
  • is_liked — TINYINT(1) — NOT NULL
  • INDEX — `bakery_id`
  • INDEX — `favorite_ibfk_1`

reservation

  • reservation_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.user_id — NOT NULL
  • bakery_id — INT — Foreign key → bakery.bakery_id — NOT NULL
  • bread_package_id — INT — Foreign key → bread_package.bread_package_id — NOT NULL
  • quantity — INT — NOT NULL
  • total_price — INT — NOT NULL
  • reserved_pickup_time — TIMESTAMP — NOT NULL
  • pickup_at — TIMESTAMP
  • created_at — TIMESTAMP
  • cancelled_at — TIMESTAMP
  • status — VARCHAR(45) — NOT NULL
  • INDEX — `user_id`
  • INDEX — `bakery_id`
  • INDEX — `reservation_ibfk_3_idx`

review

  • review_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.user_id — NOT NULL
  • bakery_id — INT — Foreign key → bakery.bakery_id — NOT NULL
  • rating — INT — NOT NULL
  • content — VARCHAR(1500)
  • review_image_url — VARCHAR(255)
  • created_at — TIMESTAMP
  • deleted_at — TIMESTAMP
  • INDEX — `user_id`
  • INDEX — `bakery_id`

settlement

  • settlement_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.user_id — NOT NULL
  • bank_name — VARCHAR(100) — NOT NULL
  • account_holder_name — VARCHAR(100) — NOT NULL
  • account_number — VARCHAR(50) — NOT NULL
  • email_for_tax_invoice — VARCHAR(255) — NOT NULL
  • business_license_file_url — VARCHAR(255)
  • created_at — TIMESTAMP
  • deleted_at — TIMESTAMP
  • INDEX — `user_id`

stock

  • stock_id — INT — Primary key — NOT NULL
  • bakery_id — INT — Foreign key → bakery.bakery_id — NOT NULL
  • bread_id — INT — Foreign key → bread.bread_id — NOT NULL
  • quantity — INT — NOT NULL
  • date — DATE — NOT NULL
  • INDEX — `bakery_id`
  • INDEX — `bread_id`

user

  • user_id — INT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(20)
  • profile_image_url — VARCHAR(255)
  • user_type — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP
  • deleted_at — TIMESTAMP
  • kakao_id — VARCHAR(50)
  • profile_photo_url — VARCHAR(255)
  • refresh_token — VARCHAR(512)