UMC_study_week0

테이블 (7)

가게 (store)

  • store_id (Key) — bigint — 기본 키 — NOT NULL
  • address (Field) — varchar(30)

내 미션 (my_mission)

  • member_id (Key) — bigint — 외래 키 → 회원.member_id — NOT NULL
  • mission_id (Key2) — bigint — 외래 키 → 미션.mission_id — NOT NULL
  • is_cleard (Field2) — int

내 알림 (my_notification)

  • notification_id (Key2) — bigint — 외래 키 → 알림.notification_id — NOT NULL
  • member_id (Key3) — bigint — 외래 키 → 회원.member_id — NOT NULL
  • content (Field2) — varchar(50)
  • is_readed (Field3) — int
  • Field — int

리뷰 (review)

  • review_id (Key) — bigint — 기본 키 — NOT NULL
  • store_id (Key2) — bigint — 외래 키 → 가게.store_id — NOT NULL
  • member_id (Field2) — bigint
  • score (Field3) — float
  • content (Field4) — varchar(100)
  • image (Field5) — varchar(100)
  • member_id (bitint) — bigint — 외래 키 → 회원.member_id — NOT NULL

미션 (mission)

  • mission_id (Key) — bigint — 기본 키 — NOT NULL
  • content (Field) — varchar(50)

알림 (notification)

  • notification_id (Key) — bigint — 기본 키 — NOT NULL
  • content (Field) — varchar(50)
  • Field2

회원 (member)

  • member_id (bitint) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(20)
  • birth (Field2) — datetime(6)
  • address (Field3) — varchar(30)
  • my_point (Field4) — bigint
  • my_reviews (Field5) — varchar(100)
  • preferred_food (Field6) — string
  • location_now (Field7) — varchar(30)
  • status (Field8) — int
  • inactive_date (Field9) — datetime(6)