WK0 mission
Tables (14)
Untitled (user)
- ID (id) — bigint — Primary key — NOT NULL
- Field (email) — varchar(20)
- Field (name) — varchar(20)
- Field (nickname) — varchar(20)
- Field2 (gender) — varchar(10)
- Field3 (birthday) — date
- Field4 (address) — varchar(100)
- Field (point) — int
- Field (role) — varchar(20)
- Field (phone_number) — varchar(20)
- Field (is_deleted) — boolean
- Field2 (updated_at) — datetime(6)
- Field (created_at) — datetime(6)
Untitled (food)
- Key (id) — bigint — Primary key — NOT NULL
- Field (food) — varchar(20)
- Field (created_at) — datetime(6)
- Field2 (updated_at) — datetime(6)
- Field (is_deleted) — boolean
Untitled (prefered_food)
- Key (id) — bigint — Primary key — NOT NULL
- ID (user_id) — bigint — Foreign key → Untitled.ID — NOT NULL
- Key (food_id) — bigint — Foreign key → Untitled.Key — NOT NULL
Untitled (user_mission)
- Key (id) — bigint — Primary key — NOT NULL
- ID (user_id) — bigint — Foreign key → Untitled.ID — NOT NULL
- Key (mission_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (is_completed) — boolean
- Field (created_at) — datetime(6)
- Field2 (updated_at) — datetime(6)
- Field (is_deleted) — boolean
Untitled (restaurant)
- Key (id) — bigint — Primary key — NOT NULL
- Key (region_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- ID (owner_id) — bigint — Foreign key → Untitled.ID — NOT NULL
- Field (name) — varchar(20)
- Field2 (type) — varchar(20)
- Field (owner_number) — varchar(20)
- Field (is_deleted) — boolean
Untitled (restaurant_region)
- Key (id) — bigint — Primary key — NOT NULL
- Field (name) — varchar(20)
Untitled (Social account)
- Key (id) — bigint — Primary key — NOT NULL
- ID (user_id) — bigint — Foreign key → Untitled.ID — NOT NULL
- Field (provider) — varchar(20)
- Field2 (provider_id) — text
Untitled (reply)
- Key (id) — bigint — Primary key — NOT NULL
- Key (review_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (content) — text
- Field (created_at) — datetime(6)
- Field2 (updated_at) — datetime(6)
- Field (is_deleted) — boolean
Untitled (Term)
- Key (id) — bigint — Primary key — NOT NULL
- Field (type) — char(255)
- Field2 (body) — text
- Field3 (version) — char(20)
- Field (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
- Field (is_deleted) — boolean
Untitled (mission)
- Key (id) — bigint — Primary key — NOT NULL
- Key (restaurant_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (condition_price) — bigint
- Field2 (award_point) — bigint
- Field (deadline) — datetime(6)
- Field (is_deleted) — boolean
Untitled (review)
- Key (id) — bigint — Primary key — NOT NULL
- Key (user_mission_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (rate) — float
- Field2 (content) — text
- Field3 (created_at) — datetime(6)
- Field (updated_at) — datetime(6)
- Field (is_deleted) — boolean
Untitled (notification)
- Key (id) — bigint — Primary key — NOT NULL
- ID (user_id) — bigint — Foreign key → Untitled.ID — NOT NULL
- Field (title) — varchar(20)
- Field2 (body) — varchar(20)
- Field (created_at) — datetime(6)
Untitled (Service Acceptance)
- Key (id) — bigint — Primary key — NOT NULL
- ID (user_id) — bigint — Foreign key → Untitled.ID — NOT NULL
- Key (term_id) — bigint — Foreign key → Untitled.Key — NOT NULL
Untitled (notification_setting)
- Key (id) — bigint — Primary key — NOT NULL
- ID (user_id) — bigint — Foreign key → Untitled.ID — NOT NULL
- Field (type) — text
- Field2 (is_enable) — boolean
- Field (updated_at) — datetime(6)