umc6
Tables (15)
Copy Of Untitled2 (Address)
- Field (do) — String
- Field2 (si) — String
- Field (gu) — String
- Field (road) — String
Food (food)
- Key (id) — Long — Primary key — NOT NULL
- id (member_id) — Long — Foreign key → Member.id — NOT NULL
- Field (food_type) — FoodType
Inquiry (inquiry)
- Key (id) — Long — Primary key — NOT NULL
- id (member_id) — Long — Foreign key → Member.id — NOT NULL
- Field (title) — String
- Field (content) — CLOB
Member (member)
- id — Long — Primary key — NOT NULL
- Field (gender) — Gender
- Field2 (birthday) — LocalDate
- Field3 (address) — Address
- Field (point) — Long
- Field (current_mission_count) — Long
- Field (email) — String
- Field (social_type) — ENUM
Untitled (store)
- Key (id) — Long — Primary key — NOT NULL
- Field (name) — String
- Field (address) — Address
- Field (store_type) — store_type
Untitled (StoreType(Enum))
- Field (CHINESE)
- Field (OKREAN)
- Field (ITIALY)
- Field (ETC)
Untitled (review)
- Key (id) — Long — Primary key — NOT NULL
- id (member_id) — Long — Foreign key → Member.id — NOT NULL
- Key (store_id) — Long — Foreign key → Untitled.Key — NOT NULL
- Field (content) — CLOB
- Field (star) — Integer
Untitled (mission)
- Key (id) — Long — Primary key — NOT NULL
- id (member_id) — Long — Foreign key → Member.id — NOT NULL
- Key (store_id) — Long — Foreign key → Untitled.Key — NOT NULL
- Field (content) — CLOB
- Field (ceo_number) — Long
- Field (min_price) — Integer
- Field (mission_status) — MissionStatus
Untitled (MissionStatus(Enum))
- Field (CLEAR)
- Field (FALE)
- Field (ONGOING)
- Field (CLEAR_REQ)
- Field (ETC)
Untitled (review_img)
- Key (id) — Long — Primary key — NOT NULL
- Key (review_id) — Long — Foreign key → Untitled.Key — NOT NULL
- Field (img_url) — String
Untitled (notification)
- Key (id) — Long — Primary key — NOT NULL
- Field (topic) — String
- Field (title) — String
- Field (content) — String
Untitled (SendStatus(Enum))
- Field (SUCCESS)
- Field2 (FALE)
- Field3 (ETC)
Untitled (notification_member)
- Key (id) — Long — Primary key — NOT NULL
- id (member_id) — Long — Foreign key → Member.id — NOT NULL
- Key (notification_id) — Long — Foreign key → Untitled.Key — NOT NULL
- Field (sendstatus) — SendStatus
- Field (notification_status) — boolean
Untitled2 (Gender(Enum))
- Field (MALE)
- Field2 (FEMALE)
- Field (NAN)
- Field (ETC)
inquiry_img
- id — Long — Primary key — NOT NULL
- Key (inquiry_id) — Long — Foreign key → Inquiry.Key — NOT NULL
- Field (img_url) — String