1주차미션

테이블 (13)

agreement (Untitled8)

  • Key — bigint — 기본 키 — NOT NULL
  • member_id (Key2) — bigint — 외래 키 → member.id — NOT NULL
  • term_id (Key3) — bigint — 외래 키 → term.id — NOT NULL
  • created_at (Field) — datetime(6)
  • updated_at (Field2) — datetime(6)

food_category (Untitled10)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(15)
  • created_at (Field2) — datetime(6)
  • updated_at (Field3) — datetime(6)

inquiry (Untitled11)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • title (Field) — varchar(50)
  • type (Field2) — varchar(20)
  • body (Field3) — varchar(50)
  • status (Field4) — varchar(15)
  • created_at (Field5) — datetime(6)
  • updated_at (Field6) — datetime(6)
  • member_id (Key2) — bigint — 외래 키 → member.id — NOT NULL

inquiry_reply (Untitled12)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • admin_id (Field) — varchar(15)
  • body (Field2) — varchar(50)
  • created_at (Field3) — datetime(6)
  • updated_at (Field4) — datetime(6)
  • inquiry_id (Key2) — bigint — 외래 키 → inquiry.id — NOT NULL

location (Untitled6)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(20)
  • created_at (Field2) — datatime(6)
  • updated_at (Field3) — datetime(6)

member (Untitled)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(20)
  • gender (Field2) — varchar(20)
  • age (Field3) — date
  • address (Field4) — varchar(40)
  • email (Field5) — varchar(40)
  • phone_num (Field6) — varchar(40)
  • total_point (Field7) — int
  • status (Field8) — varchar(15)
  • inactive_date (Field9) — datetime
  • social_type (Field10) — varchar(10)
  • created_at (Field11) — datetime(6)
  • updated_at (Field13) — datetime(6)

member_notification (Untitled13)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • member_id (Key2) — bigint — 외래 키 → member.id — NOT NULL
  • new_event (Field) — varchar(50)
  • review_deadline (Field2) — datetime(6)
  • inquiry_reply (Field3) — varchar(10)
  • created_at (Field4) — datetime(6)
  • updated_at (Field5) — datetime(6)

mission (Untitled4)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • store_id (Key2) — bigint — 외래 키 → store.id — NOT NULL
  • reward (Field) — int
  • deadline (Field2)
  • mission_spec (Field3)
  • created_at (Field4)
  • Field5

mission_member (Untitled3)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • member_id (Key2) — bigint — 외래 키 → member.id — NOT NULL
  • misson_id (Key3) — bigint — 외래 키 → mission.id — NOT NULL
  • store_id (Key22) — bigint — 외래 키 → mission.store_id — NOT NULL
  • status (Field) — varchar(15)
  • created_at (Field2) — datetime(6)
  • updated_at (Field3) — datetime(6)

preference (Untitled7)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • member_id (Key2) — bigint — 외래 키 → member.id — NOT NULL
  • category_id (Key3) — bigint — 외래 키 → food_category.id — NOT NULL
  • food (Field) — varchar(20)
  • created_at (Field2) — datetime(6)
  • updated_at (Field3) — datetime(6)

review (Untitled2)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • member_id (Key2) — bigint — 외래 키 → member.id — NOT NULL
  • store_id (Key3) — bigint — 외래 키 → store.id — NOT NULL
  • body (Field) — float
  • score (Field2) — float

store (Untitled5)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • location_id (Key2) — bigint — 외래 키 → location.id — NOT NULL
  • name (Field) — varchar(20)
  • address (Field2) — varchar(20)
  • score (Field3) — float
  • created_at (Field4) — datetime(6)
  • updated_at (Field5) — datetime(6)

term (Untitled9)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • title (Field) — varchar(20)
  • body (Field2) — text
  • optional (Field3) — location
  • created_at (Field4) — datetime(6)
  • updated_at (Field5) — datetime(6)