UMC_1st
Tables (11)
Copy Of Copy Of Copy Of member (food)
- 고유id (id) — int — Primary key — NOT NULL
- Field2 (food) — varchar(50)
Copy Of Copy Of Untitled (event_alarm)
- Key (id) — int — Foreign key → Untitled.Key — NOT NULL
- 고유id (alarm_id) — int — Foreign key → Untitled.고유id — NOT NULL
- Field (title) — string
- Field (body) — string
Copy Of Copy Of member (food_prefer)
- 고유id (id) — int — Primary key — NOT NULL
- 고유id (user_id) — varchar(50) — Foreign key → member.고유id — NOT NULL
- 고유id (food_id) — varchar(50) — Foreign key → Copy Of Copy Of Copy Of member.고유id — NOT NULL
Copy Of Copy Of member2 (restaurant)
- 고유id (id) — int — Primary key — NOT NULL
- 고유id (food_id) — int — Foreign key → Copy Of Copy Of Copy Of member.고유id — NOT NULL
- Field2 (rated) — int
- Field3 (call_num) — int
- Field4 (address) — varchar(50)
- Field5 (status) — boolean
Copy Of Copy Of member3 (mission)
- 고유id (id) — int — Primary key — NOT NULL
- 고유id (restaurant_id) — int — Foreign key → Copy Of Copy Of member2.고유id — NOT NULL
- 고유id (food_id) — int — Foreign key → Copy Of Copy Of member2.고유id — NOT NULL
- Field2 (status) — varchar(50)
- Field3 (point) — int
- Field4 (deadline) — datetime
- Field5 (content) — string
Copy Of Untitled (review_alarm)
- Key (id) — int — Foreign key → Untitled.Key — NOT NULL
- 고유id (alarm_id) — int — Foreign key → Untitled.고유id — NOT NULL
- Field (title) — string
- Field2 (body) — string
Copy Of member (mission_status)
- 고유id (id) — int — Primary key — NOT NULL
- 고유id (mission_id) — int — Foreign key → Copy Of Copy Of member3.고유id — NOT NULL
- 고유id (restaurant_id) — int — Foreign key → Copy Of Copy Of member3.고유id — NOT NULL
- 고유id (food_id) — int — Foreign key → Copy Of Copy Of member3.고유id — NOT NULL
- 고유id (user_id) — int — Foreign key → member.고유id — NOT NULL
- Field2 (status) — varchar(50)
Untitled (review)
- Key (id) — int — Primary key — NOT NULL
- 고유id (user_id) — int — Foreign key → member.고유id — NOT NULL
- 고유id (restaurant_id) — int — Foreign key → Copy Of Copy Of member2.고유id — NOT NULL
- 고유id (food_id) — int — Foreign key → Copy Of Copy Of member2.고유id — NOT NULL
- Field (content) — string
- Field2 (rated) — int
- Field3 (photo) — string
Untitled (alarm)
- Key (id) — int — Primary key — NOT NULL
- 고유id (user_id) — int — Foreign key → member.고유id — NOT NULL
- Field
Untitled (qna_alarm)
- Key (id) — int — Foreign key → Untitled.Key — NOT NULL
- 고유id (alarm_id) — int — Foreign key → Untitled.고유id — NOT NULL
- Field (title) — string
- Field (body) — string
member
- 고유id (id) — int — Primary key — NOT NULL
- Field2 (password) — varchar(50)
- Field3 (email) — varchar(50)
- Field4 (name) — varchar(10)
- Field5 (nickname) — varchar(10)
- Field6 (gender) — varchar(10)
- Field7 (point) — int
- Field8 (birth_date) — datetime
- Field (address) — varchar(50)
- Field2 (event_alarm) — boolean
- Field3 (qna_alarm) — boolean
- Field4 (review_alarm) — boolean
- Field5 (status) — varchar(15)
- Field6 (created_at) — datetime(6)
- Field7 (updated_at) — datetime(6)
- Field (inactive_date) — datetime
- Field2 (location_allow) — boolean
- Field3 (marketing_allow) — boolean