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)