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)