WorkBook Chapter 1
Tables (11)
food_category (Untitled6)
- id (Field) — bigint — Primary key
- name (Field2) — varchar(20)
mission (Untitled8)
- id (Field) — bigint — Primary key
- store_id (Field7) — bigint — Foreign key → store.id
- expired_date (Field3) — date
- description (Field4) — text
- reward_point (Field5) — int
- created_at (Field2) — datetime(6)
- updated_at (Field6) — datetime(6)
point (Untitled12)
- id (Field) — bigint — Primary key
- user_id (Field2) — bigint — Foreign key → user.id
- mission_id (Field6) — bigint — Foreign key → mission.id
- point_amount (Field3) — int
- created_at (Field4) — datetime(6)
- updated_at (Field5) — datetime(6)
region (Untitled11)
- id (Field) — bigint — Primary key
- name (Field2) — varchar(20)
- created_at (Field3) — datetime(6)
- updated_at (Field4) — datetime(6)
review (Untitled13)
- id (Field) — bigint — Primary key
- user_id (Field7) — bigint — Foreign key → user.id
- store_id (Field3) — bigint — Foreign key → store.id
- content (Field2) — text
- star_rate (Field4) — decimal(2,1)
- created_at (Field5) — datetime(6)
- updated_at (Field6) — datetime(6)
review_image (Untitled14)
- id (Field) — bigint — Primary key
- review_id (Field3) — bigint — Foreign key → review.id
- image_url (Field2) — text
- created_at (Field4) — datetime(6)
store (Untitled10)
- id (Field) — bigint — Primary key
- region_id (Field4) — bigint — Foreign key → region.id
- name (Field2) — varchar(20)
- store_category (Field3) — varchar(20)
- created_at (Field5) — datetime(6)
- updated_at (Field6) — datetime(6)
user (Untitled5)
- id (Field) — bigint — Primary key
- name (Field2) — varchar(20)
- gender (Field3) — enum(FEMALE, MALE)
- birth_date (Field4) — date
- address (Field5) — text
- phone_num (Field6) — varchar(20)
- point (Field11) — int
- status (Field9) — int
- inactive_date (Field10) — datetime
- created_at (Field7) — datetime(6)
- updated_at (Field8) — datetiem(6)
user_food_category (Untitled7)
- id (Field) — bigint — Primary key
- user_id (Field4) — bigint — Foreign key → user.id
- food_id (Field5) — bigint — Foreign key → food_category.id
- created_at (Field2) — datetime(6)
- updated_at (Field3) — datetime(6)
user_image (Untitled)
- id (Field) — bigint — Primary key
- user_id (Field4) — bigint — Foreign key → user.id
- image_url (Field2) — text
- created_at (Field3) — datetime(6)
user_mission (Untitled9)
- id (Field) — bigint — Primary key
- user_id (Field3) — bigint — Foreign key → user.id
- mission_id (Field4) — bigint — Foreign key → mission.id
- status (Field7) — int
- created_at (Field5) — datetime(6)
- updated_at (Field6) — datetime(6)