UMC_Week1
Tables (12)
Untitled (review)
- Key (id) — bigint — Primary key — NOT NULL
- id (user_id) — bigint — Foreign key → user.id — NOT NULL
- id (store_id) — bigint — Foreign key → stores.id — NOT NULL
- Field (rating) — int
- Field (description) — text
- Field (created_at) — datetime(6)
Untitled (user_mission)
- Key (id) — Primary key — NOT NULL
- id (user_id) — bigint — Foreign key → user.id — NOT NULL
- id (mission_id) — bigint — Foreign key → missions.id — NOT NULL
- Field (status) — varchar(20)
Untitled (alarm)
- Key (id) — bigint — Primary key — NOT NULL
- id (user_id) — bigint — Foreign key → user.id — NOT NULL
- Field (is_confirmed) — boolean
- Field (created_at) — datetime(6)
- Field (dtype) — varchar(20)
- Field (title) — varchar(30)
- Field (body) — text
Untitled (review_comment)
- Key (id) — bigint — Primary key — NOT NULL
- Key (review_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (body) — text
- Field (created_at) — datetime(6)
Untitled (review_images)
- Key (id) — bigint — Primary key — NOT NULL
- Key (review_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (image_url) — varchar(2048)
- Field (created_at) — datetime(6)
Untitled (inquiry)
- Key (id) — bigint — Primary key — NOT NULL
- id (user_id) — bigint — Foreign key → user.id — NOT NULL
- Field (title) — varchar(100)
- Field (created_at) — datetime(6)
- Field (status) — varchar(10)
Untitled (inquiry_images)
- Key (id) — bigint — Primary key — NOT NULL
- Key (inquiry_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (image_url) — varchar(2048)
- Field (created_at) — datetime(6)
food_category (category)
- id — bigint — Primary key — NOT NULL
- name — varchar(60)
missions
- id — bigint — Primary key — NOT NULL
- id (store_id) — bigint — Foreign key → stores.food_category_id — NOT NULL
- description — text
- point — int
- Field (expired_at) — date
stores (store)
- id — bigint — Primary key — NOT NULL
- food_category_id (category_id) — bigint — Foreign key → food_category.id — NOT NULL
- id (owner_id) — bigint — Foreign key → user.id — NOT NULL
- name — varchar(100)
- address — varchar(255)
- status — varchar(20)
user
- id — bigint — Primary key — NOT NULL
- name — varchar(30)
- birth — date
- gender — varchar(10)
- Field (email) — varchar(30)
- Field (phone_num) — varchar(15)
- address — varchar(255)
- Field (role) — varchar(10)
- Field (point) — int
- agree_location — boolean
- agree_marketing — boolean
- created_at — datetime(6)
- Field (updated_at) — datetime(6)
- Field (status) — varchar(20)
- Field (inactive_date) — datetime
- Field (alarm_new_event) — boolean
- Field2 (alarm_comment) — boolean
- Field3 (alarm_inquiry) — boolean
user_preferred_food_category (user_prefer_category)
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.id — NOT NULL
- food_category_id (category_id) — bigint — Foreign key → food_category.id — NOT NULL