UMC_Assignment2

Tables (12)

alarms

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → members.id — NOT NULL
  • is_confirmed (update_at) — boolean
  • created_at (is_confirmed) — boolean
  • updated_at (created_at) — datetime(6)

inquries

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → members.id — NOT NULL
  • content — text
  • is_answered — boolean
  • answer — text
  • created_at — datetime(6)
  • updated_at — datetime(6)

member_mission

  • id — bigint — Primary key — NOT NULL
  • members_id (id2) — bigint — Foreign key → members.id — NOT NULL
  • missions_id (id3) — bigint — Foreign key → missions.id — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)

member_preference (preferences)

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → members.id — NOT NULL
  • preference_id (Key) — bigint — Foreign key → preference.id — NOT NULL

members

  • id — bigint — Primary key — NOT NULL
  • name — varchar(20)
  • gender (nickname) — varchar(10)
  • birthdate — datetime
  • address — varchar(50)
  • email — varchar(20)
  • phone — varchar(15)
  • point — bigint
  • active — boolean
  • created_at — datetime(6)
  • updated_at — datetime(6)

missions

  • id — bigint — Primary key — NOT NULL
  • store_id (id2) — bigint — Foreign key → stores.id — NOT NULL
  • content — text
  • point — int
  • in_progress (is_progress) — boolean
  • is_done — boolean

new_mission

  • id — bigint — Primary key — NOT NULL
  • alarms_id (id2) — bigint — Foreign key → alarms.id — NOT NULL
  • title — varchar(20)
  • body — text

preference (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • preference (Field) — varchar(20)

request_review

  • id — bigint — Primary key — NOT NULL
  • alarms_id (id2) — bigint — Foreign key → alarms.id — NOT NULL
  • title — varchar(20)
  • body — text

reviews

  • id — bigint — Primary key — NOT NULL
  • store_id — bigint — Foreign key → stores.id — NOT NULL
  • member_id — bigint — Foreign key → members.id — NOT NULL
  • content — text
  • score — float
  • image — imagefield
  • created_at — datetime(6)
  • updated_at — datetime(6)

store_type

  • id — bigint — Primary key — NOT NULL
  • type — varchar(20)

stores

  • id — bigint — Primary key — NOT NULL
  • store_type_id — bigint — Foreign key → store_type.id — NOT NULL
  • store_name (Field) — varchar(20)
  • address (Field2) — varchar(50)
  • latitude (Field3) — float
  • longitude (Field4) — float
  • is_opened (Field5) — boolean
  • created_at — datetime(6)
  • updated_at — datetime(6)