umc
Tables (15)
Untitled (member)
- Key (id) — bigint — Primary key — NOT NULL
- Field (name) — varchar(10) — NOT NULL
- Field (gender) — varchar(6) — NOT NULL
- Field (phone_number) — varchar(20) — NOT NULL
- Field (birth_date) — date — NOT NULL
- Field (status) — varchar(15) — NOT NULL
- Field (inactive_at) — date — NOT NULL
- Field (province) — varchar(50) — NOT NULL
- Field (city) — varchar(50) — NOT NULL
- Field (street) — varchar(50) — NOT NULL
- Field (detail) — varchar(50) — NOT NULL
- Field (zipcode) — varchar(10) — NOT NULL
- Field (created_at) — datetime(6) — NOT NULL
- Field (updated_at) — datetime(6) — NOT NULL
Untitled (food_category)
- Key (id) — bigint — Primary key — NOT NULL
- Field (name) — varchar(10) — NOT NULL
Untitled (favorite_food_category)
- Key (id) — bigint — Primary key — NOT NULL
- Key (food_category_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (customer_id) — bigint — Foreign key → Untitled.Key — NOT NULL
Untitled (mission)
- Key (id) — bigint — Primary key — NOT NULL
- Key (store_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (condition) — int — NOT NULL
- Field (reward) — double — NOT NULL
- Field (created_at) — datetime(6) — NOT NULL
- Field (updated_at) — datetime(6) — NOT NULL
Untitled (member_mission)
- Key (id) — bigint — Primary key — NOT NULL
- Key (mission_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (customer_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (status) — varchar(20) — NOT NULL
- Field (created_at) — datetime(6) — NOT NULL
- Field (updated_at) — datetime(6) — NOT NULL
Untitled (store_owner)
- Key (id) — bigint — Primary key — NOT NULL
- Key (member_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (store_main_address) — varchar(100) — NOT NULL
- Field (store_detail_address) — varchar(100) — NOT NULL
- Field (owner_number) — varchar(30) — NOT NULL
Untitled (customer)
- Key (id) — bigint — Primary key — NOT NULL
- Key (member_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (point) — int — NOT NULL
Untitled (review_image)
- Key (id) — bigint — Primary key — NOT NULL
- Key (review_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (image_url) — varchar(255) — NOT NULL
- Field (created_at) — datetime(6) — NOT NULL
- Field (updated_at) — datetime(6) — NOT NULL
Untitled (alarm)
- Key (id) — bigint — Primary key — NOT NULL
- Key (customer_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (is_read) — boolean — NOT NULL
- Field (created_at) — datetime(6) — NOT NULL
- Field (updated_at) — datetime(6) — NOT NULL
Untitled (mission_alarm)
- Key (id) — bigint — Primary key — NOT NULL
- Key (alarm_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (title) — varchar(100) — NOT NULL
- Field (body) — varchar(100) — NOT NULL
Untitled (review_alarm)
- Key (id) — bigint — Primary key — NOT NULL
- Key (alarm_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (title) — varchar(100) — NOT NULL
- Field (body) — varchar(100) — NOT NULL
Untitled (marketing_alarm)
- Key (id) — bigint — Primary key — NOT NULL
- Key (alarm_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (title) — varchar(100) — NOT NULL
- Field (body) — varchar(100) — NOT NULL
Untitled (store)
- Key (id) — bigint — Primary key — NOT NULL
- Key (store_owner_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (category_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (name) — varchar(30) — NOT NULL
- Field (province) — varchar(100) — NOT NULL
- Field (city) — varchar(50) — NOT NULL
- Field (street) — varchar(50) — NOT NULL
- Field (detail) — varchar(50) — NOT NULL
- Field (zipcode) — varchar(10) — NOT NULL
- Field (phone_number) — varchar(20) — NOT NULL
- Field (open_at) — time — NOT NULL
- Field (close_at) — time — NOT NULL
- Field (rating) — double — NOT NULL
Untitled (comment)
- Key (id) — bigint — Primary key — NOT NULL
- Key (review_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (customer_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (parent_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (content) — text — NOT NULL
Untitled (review)
- Key (id) — bigint — Primary key — NOT NULL
- Key (store_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (customer_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (content) — text — NOT NULL
- Field (rating) — double — NOT NULL
- Field (created_at) — datetime(6) — NOT NULL
- Field (updated_at) — datetime(6) — NOT NULL