umc5기스터디

테이블 (13)

Untitled (FoodType)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Field (name) — VARCHAR(10) — NOT NULL
  • Field2 (info) — VARCHAR(10)

Untitled (MemberFoodType)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • 기본키 (member_id) — BIGINT — 외래 키 → 회원.기본키 — NOT NULL
  • Key (food_type_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL

Untitled (Mission)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Key (store_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Field (content) — VARCHAR(30) — NOT NULL
  • Field2 (price) — INT — NOT NULL — 얼마 이상
  • Field3 (point) — INT — NOT NULL
  • Field4 (end_date) — DATETIME — NOT NULL — 마감 기한
  • Field2 (auth_code) — VARCHAR(30) — NOT NULL — 인증 코드
  • Field (created_at) — DATETIME — NOT NULL
  • Field (updated_at) — DATETIME
  • Field3 (status) — BOOLEAN

Untitled (Store)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Key (region_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — VARCHAR(30) — NOT NULL
  • Field (type) — VARCHAR(10) — NOT NULL — 음식점 타입
  • Field (address) — VARCHAR(30) — NOT NULL
  • Field (state) — VARCHAR(10) — 영업 상태
  • Field (rating) — DOUBLE
  • Field (created_at) — DATETIME — NOT NULL
  • Field2 (updated_at) — DATETIME
  • Field3 (status) — BOOLEAN

Untitled (Review)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • 기본키 (member_id) — BIGINT — 외래 키 → 회원.기본키 — NOT NULL
  • Key (store_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Field2 (content) — VARCHAR(30) — NOT NULL
  • Field (rating) — DOUBLE
  • Field (created_at) — DATETIME — NOT NULL
  • Field2 (updated_at) — DATETIME
  • Field3 (status) — BOOLEAN

Untitled (StoreImage)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Key (store_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Field (img_urls) — TEXT — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Field2 (updated_at) — DATETIME

Untitled (ReviewImage)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Key (review_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Field (img_urls) — TEXT — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Field2 (updated_at) — DATETIME

Untitled (Inquiry)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • 기본키 (member_id) — BIGINT — 외래 키 → 회원.기본키 — NOT NULL
  • Field (title) — VARCHAR(30) — NOT NULL
  • Field2 (content) — VARCHAR(200) — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Field2 (updated_at) — DATETIME
  • Field (status) — BOOLEAN

Untitled (InquiryImage)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Key (inquiry_id) — BIGINNT — 외래 키 → Untitled.Key — NOT NULL
  • Field (img_urls) — TEXT — NOT NULL
  • Field (created_at)
  • Field2 (updated_at)

Untitled (Alarm)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • 기본키 (member_id) — BIGINT — 외래 키 → 회원.기본키 — NOT NULL
  • Field (content) — VARCHAR(10) — NOT NULL
  • Field2 (created_at) — DATETIME — NOT NULL
  • Field (updated_at) — DATETIME
  • Field (alarm_type) — ENUM — NOT NULL
  • Field (status) — BOOLEAN

Untitled (MemberMission)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • 기본키 (member_id) — BIGINT — 외래 키 → 회원.기본키 — NOT NULL
  • Key (mission_id) — BIGINT — 외래 키 → Untitled.Key — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Field2 (updated_at) — DATETIME
  • Field (status) — BOOLEAN
  • Field (state) — INT — NOT NULL — 0:진행중,1:진행완료,2:실패?

Untitled (Region)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Field (name) — VARCHAR(20) — NOT NULL
  • Field2 (created_at) — DATETIME — NOT NULL
  • Field3 (updated_at) — DATETIME

회원 (Member)

  • 기본키 (id) — BIGINT — 기본 키 — NOT NULL
  • (email) — VARCHAR(10) — NOT NULL
  • Field2 (social_type) — ENUM — NOT NULL — 구글,네이버,카카오,애플
  • Field3 (name) — VARCHAR(10) — NOT NULL
  • Field4 (gender) — INT — NOT NULL — 0:남자,1:여자
  • Field (point) — INT
  • Field (birth_date) — DATETIME — NOT NULL
  • Field (address) — VARCHAR(10) — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Field (updated_at) — DATETIME
  • Field (status) — BOOLEAN
  • Field (nickname) — VARCHAR(10)
  • Field2 (phone_number) — VARCHAR(11)