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)