week4
Tables (12)
Untitled (market)
- Key (id) — bigint — Primary key — NOT NULL
- Field (boss_num) — bigint
- Field2 (name) — varchar(45)
- Field3 (address) — text
- Field4 (open) — tinyint
- Field5 (ratings) — float
- Field6 (created_at) — datetime
- Field7 (updated_at) — datetime
- Key (category_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (region_id) — bigint — Foreign key → Untitled.Key — NOT NULL
Untitled (mission)
- Key (id) — bigint — Primary key — NOT NULL
- Field (title) — varchar(45)
- Field2 (d_day) — int
- Field3 (created_at) — datetime
- Field4 (updated_at) — datetime
- Key (market_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (point) — int
Untitled (category)
- Key (id) — bigint — Primary key — NOT NULL
- Field (name) — varchar(10)
- Field2 (created_at) — datetime
- Field3 (updated_at) — datetime
Untitled (mission_of_me)
- Key (id) — bigint — Primary key — NOT NULL
- id (user_id) — bigint — Foreign key → user.id — pk
- Key (mission_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (progress) — tinyint
- Field (created_at) — datetime
- Field (updated_at) — datetime
Untitled (review)
- Key (id) — bigint — Primary key — NOT NULL
- id (user_id) — bigint — Foreign key → user.id — pk
- Key (market_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (description) — text
- Field2 (ratings) — float
- Field3 (created_at) — datetime
- Field (updated_at) — datetime
Untitled (comment)
- Key (id) — bigint — Primary key — NOT NULL
- Field (description) — text
- Field (created_at) — datetime
- Field2 (updated_at) — datetime
- Key (review_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- id (user_id) — bigint — Foreign key → Untitled.id — pk
- Key (market_id) — bigint — Foreign key → Untitled.Key — NOT NULL
Untitled (inquiry)
- Key (id) — bigint — Primary key — NOT NULL
- Field (title) — varchar(20)
- Field2 (content) — text
- Field (image) — text
- Field
- Field (created_at) — datetime
- Field (updated_at) — datetime
- id (user_id) — bigint — Foreign key → user.id — pk
Untitled (inquiry_type)
- Key (id) — bigint — Primary key — NOT NULL
- Field (name) — varchar(10)
- Key (inquiry_id) — bigint — Foreign key → Untitled.Key — NOT NULL
Untitled (review_img)
- Key (id) — bigint — Primary key — NOT NULL
- Field (img_url) — text
- Field2 (created_at) — datetime
- Field (updated_at) — datetime
- Field
- Key (review_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- id (user_id) — bigint — Foreign key → Untitled.id — pk
- Key (market_id) — bigint — Foreign key → Untitled.Key — NOT NULL
Untitled (region)
- Key (id) — bigint — Primary key — NOT NULL
- Field (name) — varchar(10)
- Field2 (created_at) — datetime
- Field3 (updated_at) — datetime
alarm
- Key (id) — bigint — Primary key — NOT NULL
- Field (is_confirmed) — tinyint
- Field2 (created_at) — datetime
- Field3 (updated_at) — datetime
- Field4 (dtype) — varchar(10)
- Field (title) — varchar(30)
- Field (body) — text
- id (user_id) — bigint — Foreign key → user.id — pk
user
- id — bigint — Primary key — pk
- Field2 (account_type) — varchar(10)
- Field3 (user_id) — varchar(10)
- Field4 (pw) — varchar(10)
- Field5 (name) — varchar(10)
- Field (gender) — tinyint
- Field (birth) — varchar(10)
- Field (address) — text
- Field2 (point) — float
- Field3 (created_at) — datetime
- Field4 (updated_at) — datetime
- Field (status) — tinyint
- Field (inactive_date) — datetime