UMCTEST
Tables (10)
Food
- id — Primary key — NOT NULL
- category — VARCHAR(50) — NOT NULL
Inquiry
- Key — Primary key — NOT NULL
- id — BIGINT
- title — VARCHAR(100)
- content — TEXT
- question_type — ENUM('GENERAL','BUG','ETC') — NOT NULL
- image_url — VARCHAR(255)
- user_id — BIGINT — NOT NULL
- created_at — DATETIME
- deleted_at — DATETIME
- id (id2) — Foreign key → User.id — NOT NULL
Mission
- Key — Primary key — NOT NULL
- id — BIGINT
- user_id — BIGINT — NOT NULL
- store_id — BIGINT — NOT NULL
- created_at — DATETIME
- id (id2) — Foreign key → User.id — NOT NULL
Notification
- id (Key) — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- title — VARCHAR(100)
- content — TEXT
- is_read — BOOLEAN
- created_at — DATETIME
- Field
- id (id2) — Foreign key → User.id — NOT NULL
Review
- Key — Primary key — NOT NULL
- id — BIGINT
- star_point — TINYINT — NOT NULL
- content — TEXT
- created_at — DATETIME
- deleted_at — DATETIME
- user_id — BIGINT — NOT NULL
- id (id2) — Foreign key → User.id — NOT NULL
ReviewComment
- Key — Primary key — NOT NULL
- id — BIGINT
- content — TEXT
- created_at — DATETIME
- review_id — BIGINT — NOT NULL
- Key (Key2) — Foreign key → Review.Key — NOT NULL
Store
- id — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- region — VARCHAR(50)
- Key — Foreign key → UserVisitedStore.Key — NOT NULL
- Key (Key2) — Foreign key → Mission.Key — NOT NULL
User
- id — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- gender — ENUM('MALE','FEMALE','OTHER') — NOT NULL
- birth_date — DATETIME
- address — VARCHAR(255)
- point — BIGINT
- phone_number — VARCHAR(20)
- email — VARCHAR(100)
- is_phone_verified — BOOLEAN
- is_notification_enabled — BOOLEAN
- is_deleted — BOOLEAN
- created_at — DATETIME
UserFavoriteFood
- id — Primary key — NOT NULL
- user_id — BIGINT — NOT NULL
- food_id — BIGINT — NOT NULL
- id (id2) — Foreign key → User.id — NOT NULL
- id (id3) — Foreign key → Food.id — NOT NULL
UserVisitedStore
- Key — Primary key — NOT NULL
- id — BIGINT
- user_id — BIGINT — NOT NULL
- store_id — BIGINT — NOT NULL
- created_at — DATETIME
- id (id2) — Foreign key → User.id — NOT NULL