UMC

Tables (6)

food

  • id — int unsigned auto_increment — Primary key — NOT NULL
  • store_id — int unsigned auto_increment — Foreign key → store.id — NOT NULL
  • menu — varchar(15)
  • price — int(10)
  • created_at — datetime(6)
  • updated_at — datetime(6)

mission

  • id — int unsigned auto_increment — Primary key — NOT NULL
  • status — varchar(30)
  • point — int
  • mission_spec — varchar(255)
  • deadline — datetime
  • create_date — datetime(6)
  • updated_date — datetime(6)

review

  • id — int unsigned auto_increment — Primary key — NOT NULL
  • user_id — int unsigned auto_increment — Foreign key → user.id — NOT NULL
  • store_id — int unsigned auto_increment — Foreign key → store.id — NOT NULL
  • rate — float
  • body — text
  • created_at — int unsigned auto_increment
  • updated_at — int unsigned auto_increment

store

  • id — int unsigned auto_increment — Primary key — NOT NULL
  • name — varchar(30)
  • address — varchar(50)
  • city — varchar(10)
  • info — varchar(255)
  • rating — float
  • created_at — datetime(6)
  • updated_at — datetime(6)

user

  • id — int unsigned auto_increment — Primary key — NOT NULL
  • password — varchar(255)
  • gender — varchar(5)
  • name — varchar(100)
  • birth — timestamp
  • email — varchar(100)
  • phone — varchar(30)
  • address — varchar(30)
  • city — varchar(10)
  • point — int
  • status — varchar(15)
  • inactive_at — datetime(6)
  • created_at — datetime(6)
  • updated_at — datetime(6)

user_mission

  • id — int unsigned auto_increment — Primary key — NOT NULL
  • mission_id — int unsigned auto_increment — Foreign key → mission.id — NOT NULL
  • user_id — int unsigned auto_increment — Foreign key → user.id — NOT NULL
  • status — varchar(30)
  • created_at — datetime(6)
  • updated_at — datetime(6)