UMCweek1

Tables (8)

food_category

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(15)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

inquiries

  • id — BIGINT — Primary key — NOT NULL
  • id (users_id) — BIGINT — Foreign key → users.id — NOT NULL
  • subject — VARCHAR(255) — NOT NULL
  • inquirytype — VARCHAR(100)
  • inquirytext — TEXT — NOT NULL
  • inquirydate — DATETIME(6)
  • inquiryPhoto (inquiryphoto) — VARCHAR(255)
  • status — VARCHAR(50)

missions

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • reward — INT
  • deadline — DATETIME
  • information — TEXT
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)

preferencefoods (preferencefood)

  • id — BIGINT — Primary key — NOT NULL
  • id (users_id) — BIGINT — Foreign key → users.id — NOT NULL
  • id (food_category_id) — BIGINT — Foreign key → food_category.id — NOT NULL
  • crated_at (created_at) — DATETIME(6)
  • updated_at — DATETIME(6)

reviews

  • id — BIGINT — Primary key — NOT NULL
  • id (users_id) — BIGINT — Foreign key → users.id — NOT NULL
  • id (shops_id) — BIGINT — Foreign key → shops.id
  • rating — DECIMAL(2,1) — NOT NULL
  • text — TEXT
  • photo — VARCHAR(255)

shops

  • id — BIGINT — Primary key
  • name — VARCHAR(30) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6)
  • photo — VARCHAR(255)
  • rating — DECIMAL(2,1)

users

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • ageverication — TINYINT(1)
  • termsaccepted — TINYINT(1) — 0
  • nickname — VARCHAR(45) — NOT NULL
  • privacypolicyaccepted — TINYINT(1)
  • locationconsent — TINYINT(1)
  • marketingconsent — TINYINT(1)
  • gender — ENUM('M', 'F', 'Other')
  • birthdate — DATE — NOT NULL
  • address — VARCHAR(200)
  • email — VARCHAR(100) — NOT NULL
  • phonenumber — VARCHAR(45)
  • point — INT

users_missions

  • id — BIGINT — Primary key — NOT NULL
  • id (users_id) — BIGINT — Foreign key → users.id — NOT NULL
  • id (missions_id) — BIGINT — Foreign key → missions.id — NOT NULL
  • status — VARCHAR(15)
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)