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)