UMC_과제
테이블 (12)
Untitled (stores)
- Key (store_id) — BIGINT — 기본 키 — NOT NULL
- Field (address) — VARCHAR(512)
- Field (store_name) — VARCHAR(255)
- Key (category_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
Untitled (categories)
- Key (category_id) — BIGINT — 기본 키 — NOT NULL
- Field (category_name) — VARCHAR(100)
- Key (user_id) — BIGINT — 외래 키 → users.Key — NOT NULL
Untitled (missions)
- Key (mission_id) — BIGINT — 기본 키 — NOT NULL
- Key (store_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Key (user_id) — BIGINT — 외래 키 → users.Key — NOT NULL
- Field (mission_point) — INT
- Field (status) — VARCHAR(20)
- Field (target_amount) — INT
Untitled (reviews)
- Key (review_id) — BIGINT — 기본 키 — NOT NULL
- Key (user_id) — BIGINT — 외래 키 → users.Key — NOT NULL
- Key (store_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Field (content) — VARCHAR(512)
- Field (created_at) — DATETIME
- Field (star) — TINYINT
Untitled (review_images)
- Key (review_image_id) — BIGINT — 기본 키 — NOT NULL
- Key (review_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Field (image_url) — VARCHAR(512)
Untitled (replies)
- Key (reply_id) — BIGINT — 기본 키 — NOT NULL
- Key (review_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Key (user_id) — BIGINT — 외래 키 → users.Key — NOT NULL
- Field (content) — VARCHAR(512)
- Field (created_at) — DATETIME
Untitled (store_hours)
- Key (store_hour_id) — BIGIINT — 기본 키 — NOT NULL
- Key (store_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Field (day_of_week) — TINYINT
- Field (open_time) — TIME
- Field (close_time) — TIME
- Field (is_day_off) — BOOLEAN
Untitled (inquiries)
- Key (inquiry_id) — BIGINT — 기본 키 — NOT NULL
- Key (user_id) — BIGINT — 외래 키 → users.Key — NOT NULL
- Field (title) — VARCHAR(255)
- Field (content) — VARCHAR(512)
- Field (status) — VARCHAR(100)
- Field (created_at) — DATETIME
Untitled (inquiry_images)
- Key (inquiry_image_id) — BIGINT — 기본 키 — NOT NULL
- Field (inquiry_image_url) — VARCHAR(512)
- Key (inquiry_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
Untitled (notices)
- Key (notice_id) — BIGINT — 기본 키 — NOT NULL
- Field (created_at) — DATETIME
- Key (notice_category_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
- Key (user_id) — BIGINT — 외래 키 → users.Key — NOT NULL
- Field (is_read) — BOOLEAN
Untitled (notice_type)
- Key (notice_category_id) — BIGINT — 기본 키 — NOT NULL
- Field (notice_type_name) — VARCHAR(100)
users
- Key (user_id) — BIGINT — 기본 키 — NOT NULL
- Field (email) — VARCHAR(255)
- Field (password) — VARCHAR(255)
- Field (provider) — VARCHAR(20)
- Field (name) — VARCHAR(100)
- Field (gender) — VARCHAR(20)
- Field (preference) — VARCHAR(100)
- Field (address) — VARCHAR(512)
- Field (birthdate) — DATE
- Field (created_at) — DATETIME
- Field (deleted_at) — DATETIME
- Field (point) — INT
- Field (allow_location_sevice) — BOOLEAN
- Field (allow_marketing) — BOOLEAN
- Field (allow_new_event_notice) — BOOLEAN
- Field (allow_review_reply_notice) — BOOLEAN
- Field (allow_inquiry_notice) — BOOLEAN
- Field (is_mobile_authenticated) — BOOLEAN