umc
Tables (11)
Copy Of Copy Of user (social_login)
- Key (social_login_id) — BIGINT — Primary key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → user.Key — NOT NULL
- Field2 (social_code) — INT
- Field4 (access_token) — VARCHAR(256)
Copy Of user (user_authentication)
- Key (auth_id) — BIGINT — Primary key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → user.Key — NOT NULL
- Field2 (birthday) — VARCHAR(20)
- Field3 (gender) — INT
- Field4 (address) — VARCHAR(20)
- Field5 (auth_date) — VARCHAR(20)
Untitled (user_password)
- Key (password_id) — BIGINT — Primary key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → user.Key — NOT NULL
- Field (salt) — VARCHAR(20)
- Field (password) — VARCHAR(20)
Untitled (user_profile)
- Key (profile_id) — BIGINT — Primary key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → user.Key — NOT NULL
- Field (nickname) — VARCHAR(20)
- Field2 (phone_num) — VARCHAR(20)
Untitled (favorite)
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (food_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → user.Key — NOT NULL
Untitled (mission)
- Key (mission_id) — BIGINT — Primary key — NOT NULL
- Field (point) — BIGINT
- Field2 (description) — TEXT
Untitled (mission_status)
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → user.Key — NOT NULL
- Key (mission_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (status) — VARCHAR(20)
Untitled (restaurant)
- Key (rest_id) — BIGINT — Primary key — NOT NULL
- Key (food_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (name) — VARCHAR(30)
- Field (address) — VARCHAR(30)
- Field (grade) — INT
Untitled (food)
- Key (food_id) — BIGINT — Primary key — NOT NULL
- Field (food_name) — VARCHAR(20)
Untitled (review)
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (rest_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (food_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Field (image_url) — VARCHAR(100)
- Field (content) — TEXT
- Field (grade) — INT
user
- Key (user_id) — BIGINT — Primary key — NOT NULL
- Field (user_name) — VARCHAR(20)
- Field2 (login_type) — VARCHAR(20)
- Field3 (created_at) — DATETIME(6)
- Field4 (updated_at) — DATETIME(6)
- Field5 (status) — VARCHAR(15)