umc-4주차

테이블 (11)

category (Untitled2)

  • id (Key) — int — 기본 키 — NOT NULL
  • name (Field) — varchar(20)

inquiry (Untitled10)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • title (Field) — varchar(50)
  • content (Field2) — text
  • type (Field3) — varchar(10)
  • member_id (Key2) — bigint — 외래 키 → member.id — NOT NULL
  • status (Field4) — varchar(20)

inquiry_image (Untitled11)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • url (Field) — varchar(255)
  • inquiry_id (Key2) — bigint — 외래 키 → inquiry.id — NOT NULL

member (Untitled)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(10)
  • sex (Field2) — varchar(10)
  • birth (Field3) — date
  • address (Field4) — varchar(255)
  • location_agree (Field5) — tynyint(1)
  • marketing_agree (Field6) — tynyint(1)
  • create_at (Field7) — datetime(6)
  • update_at (Field8) — datetime(6)
  • status (Field9) — varchar(20)
  • inactive_date (Field10) — datetime
  • point (Field11) — int

member_like (Untitled3)

  • id (Field) — bigint
  • member_id (Key) — bigint — 외래 키 → member.id — NOT NULL
  • category_id (Key2) — int — 외래 키 → category.id — NOT NULL

member_mission (Untitled9)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • status (Field) — varchar(20)
  • member_id (Key2) — bigint — 외래 키 → member.id — NOT NULL
  • mission_id (Key3) — bigint — 외래 키 → mission.id — NOT NULL

mission (Untitled8)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • point (Field) — int
  • id (Key2) — bigint — 외래 키 → store.id — NOT NULL
  • content (Field2) — varchar(255)

region (Untitled5)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(20)

review (Untitled6)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • content (Field) — text
  • member_id (Key2) — bigint — 외래 키 → member.id — NOT NULL
  • store_id (Key3) — bigint — 외래 키 → store.id — NOT NULL
  • score (Field2) — demical(3,1)
  • created_at (Field3) — datetime(6)
  • updated_at (Field4) — datetime(6)

review_image (Untitled7)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • url (Field) — varchar(255)
  • review_id (Key2) — bigint — 외래 키 → review.id — NOT NULL

store (Untitled4)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(50)
  • id (Key2) — bigint — 외래 키 → region.id — NOT NULL
  • address (Field2) — varchar(255)