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)