umc

Tables (7)

User (Untitled)

  • idx (Key) — integer — Primary key — NOT NULL
  • email (Field) — varchar(100)
  • name (Field2) — varchar(100)
  • phone (Field3) — varchar(100)
  • birthday (Field5) — varchar(100)
  • address (Field6) — varchar(100)
  • status (Field7) — varchar(100)
  • point (Field8) — varchar(100)
  • createdDate (Field9) — datetime(6)
  • modifiedDate (Field10) — datetime(6)

food (Untitled3)

  • foodIdx (Key) — Integer — Primary key — NOT NULL
  • menu (Field) — varchar(100)
  • price (Field2) — integer
  • createdDate (Field3) — datetime(6)
  • modifiedDate (Field4) — datetime(6)

mission (CopyOfUntitled3)

  • idx (Key) — Integer — Primary key — NOT NULL
  • menu (Field) — enum
  • price (Field2) — integer
  • missionSpec (Field5) — varchar(255)
  • deadlineDate (Field6) — datetime(6)
  • createdDate (Field3) — datetime(6)
  • modifiedDate (Field4) — datetime(6)

review

  • idx (Key) — integer — Primary key — NOT NULL
  • userIdx (Key2) — integer — Foreign key → User.idx — NOT NULL
  • storeIdx (Key3) — integer — Foreign key → store.idx — NOT NULL
  • rate (Field) — float
  • body (Field2) — varchar(255)
  • createdDate (Field9) — datetime(6)
  • modifiedDate (Field10) — datetime(6)

store

  • idx (Key) — integer — Primary key — NOT NULL
  • name (Field2) — varchar(100)
  • address (Field6) — varchar(100)
  • city (Field7) — varchar(100)
  • info (Field8) — varchar(100)
  • rate (Field) — float
  • createdDate (Field9) — datetime(6)
  • modifiedDate (Field10) — datetime(6)

user_like_food (Untitled2)

  • useridx (Key3) — integer — Foreign key → User.idx — NOT NULL
  • foodIdx (Key) — Integer — Foreign key → food.foodIdx — NOT NULL
  • createdDate (Field) — datetime(6)
  • Field2 — datetime(6)

usermission (CopyOfUntitled)

  • idx (Key) — integer — Primary key — NOT NULL
  • userIdx (Key2) — integer — Foreign key → User.idx — NOT NULL
  • missionIdx (Key3) — Integer — Foreign key → mission.idx — NOT NULL
  • status (Field) — enum
  • createdDate (Field9) — datetime(6)
  • modifiedDate (Field10) — datetime(6)