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