for_umc2
Tables (13)
alarm
- id — bigint — Primary key
- title — varchar(50) — NOT NULL
- content — text — NOT NULL
- dtype — varchar(20) — NOT NULL
- created_at — datetime(6)
- updated_at — datetime(6)
- is_read (Field) — tinyint(1)
- read_at (Field2) — datetime(6)
food
- id — bigint — Primary key
- name — varchar(20)
- created_at — datetime(6)
- updated_at — datetime(6)
mission
- id — bigint — Primary key
- store_id — bigint — NOT NULL
- title — varchar(100) — NOT NULL
- reward_point — int
- created_at — datetime(6)
- updated_at — datetime(6)
- store_id (id2) — bigint — Foreign key → store.id
point_history
- id — bigint — Primary key
- change_type — enum
- amount_point — int — NOT NULL
- content — varchar(30)
- created_at — datetime(6)
- user_id (id2) — bigint — Foreign key → user.id
- store_id (id3) — bigint — Foreign key → store.id
preferred_food
- id — bigint — Primary key
- updated_at (field2)
- created_at — datetime(6)
- user_id — bigint — Foreign key → user.id
- food_id — bigint — Foreign key → food.id
review
- id — bigint — Primary key
- rating — decimal(2, 1) — NOT NULL
- content — text
- created_at — datetime(6)
- updated_at — datetime(6)
- user_id (id2) — bigint — Foreign key → user.id
- store_id (id3) — bigint — Foreign key → store.id
review_answer
- id — bigint — Primary key
- content — varchar(400)
- created_at — datetime(6)
- review_id (id2) — bigint — Foreign key → review.id
- store_id (id3) — bigint — Foreign key → store.id
review_image
- id — bigint — Primary key
- image_url — varchar(100) — NOT NULL
- created_at — datetime(6)
- review_id (id2) — bigint — Foreign key → review.id
social_account
- id — bigint — Primary key
- social_type — enum
- social_id — varchar(30) — NOT NULL
- refresh_token — varchar(255)
- email — varchar(50)
- created_at — datetime(6)
- updated_at — datetime(6)
- user_id (id2) — bigint — Foreign key → user.id
store
- id — bigint — Primary key
- name — varchar(20) — NOT NULL
- address — varchar(40) — NOT NULL
- latitude — decimal(10, 7)
- longitude — decimal(10, 7)
- created_at — datetime(6)
- updated_at — datetime(6)
user
- id — bigint — Primary key
- email — varchar(100)
- password — varchar(255)
- name — varchar(10)
- gender — enum
- birth_date — date
- address — varchar(40)
- phone_number — varchar(15)
- created_at — datetime(6)
- updated_at — datetime(6)
- status — enum
- id (id2) — bigint — Foreign key → alarm.id
user_consent
- id — bigint — Primary key
- is_required — tinyint(1) — NOT NULL
- location_agree — tinyint(1)
- marketing_agree — tinyint(1)
- created_at — datetime(6)
- updated_at — datetime(6)
- user_id — bigint — Foreign key → user.id
user_mission
- id — bigint — Primary key
- status — enum
- created_at — datetime(6)
- updated_at — datetime(6)
- requested_at — datetime(6)
- completed_at — datetime(6)
- user_id (id2) — bigint — Foreign key → user.id
- mission_id (id3) — bigint — Foreign key → mission.id