UMC
Tables (8)
category (Untitled8)
- PK (id) — bigint — Primary key — NOT NULL
- (createdAt) — datetime(6)
- (updatedAt) — datetime(6)
- (categoryname) — varchar(10)
member (Untitled)
- PK (Key) — bigint — Primary key — NOT NULL
- (name) — varchar(10)
- (gender) — varchar(10)
- (birth) — datetime(6)
- (address1) — varchar(30)
- (address2) — varchar(30)
- (createdAt) — datetime(6)
- (updatedAt) — datetime(6)
- (deactivateAt) — datetime(6)
- (point) — int
- (locationTerm) — boolean
- (MarkettingTerm) — boolean
- (status) — varchar(10)
mission (Untitled7)
- PK (id) — bigint — Primary key — NOT NULL
- PK (storeid) — bigint — Foreign key → store.PK — NOT NULL
- (deadline) — datetime(6)
- (point) — int
- (missionbody) — varchar(50)
- (createdAt) — datetime(6)
- (updatedAt) — datetime(6)
mission_member (Untitled2)
- PK (id) — bigint — Primary key — NOT NULL
- FK (memberid) — bigint — Foreign key → member.PK — NOT NULL
- PK (missionid) — bigint — Foreign key → mission.PK — NOT NULL
- (isCleared) — boolean
- (createdAt) — datetime(6)
- (updatedAt) — datetime(6)
prefer (Untitled6)
- PK (id) — bigint — Primary key — NOT NULL
- FK (categoryid) — bigint — Foreign key → category.PK — NOT NULL
- FK (memberid) — bigint — Foreign key → member.PK — NOT NULL
- (category) — varchar(15)
- (createdAt) — datetime(6)
- (updatedAt) — datetime(6)
review (Untitled3)
- PK (id) — bigint — Primary key — NOT NULL
- FK (memberid) — bigint — Foreign key → member.PK — NOT NULL
- FK (storeid) — bigint — Foreign key → store.PK — NOT NULL
- (nickname) — varchar(10)
- (body) — text
- (score) — float
- (createdAt) — datetime(6)
- (deletedAt) — datetime(6)
reviewImage (Untitled5)
- PK (id) — bigint — Primary key — NOT NULL
- FK (reviewID) — bigint — Foreign key → review.FK — NOT NULL
- (storeid) — varchar(20)
- (url) — text
- (createdAt) — datetime(6)
- (updatedAt) — datetime(6)
store (Untitled4)
- PK (id) — bigint — Primary key — NOT NULL
- (storename) — varchar(15)
- (storescore) — float
- (category) — varchar(15)
- (address) — varchar(30)
- (createdAt) — datetime(6)
- (updatedAt) — datetime(6)