10th week0
Tables (18)
business_time (Untitled13)
- business_time_id (Key) — bigint — Primary key — NOT NULL
- start_time (Field) — time — NOT NULL
- end_time (Field2) — time — NOT NULL
food_category (음식카테고리)
- food_category_id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar2 — NOT NULL
food_member (사용자-음식카테고리)
- id (Key) — bigint — Primary key — NOT NULL
- food_category_id (Key2) — bigint — Foreign key → food_category.food_category_id — NOT NULL
- member_id (Key3) — bigint — Foreign key → member.member_id — NOT NULL
member (Untitled)
- member_id (Key) — bigint — Primary key — NOT NULL
- gender (Field) — varchar2 — NOT NULL — ENUM(MALE, FEMALE, NONE)
- birthday (Field2) — date — NOT NULL
- address (Field3) — varchar2 — NOT NULL
- email (Field4) — varchar2 — NOT NULL
- phone (Field5) — varchar2 — NOT NULL
- point (Field6) — bigint — NOT NULL
member_mission (Untitled8)
- member_mission_id (Key) — bigint — Primary key — NOT NULL
- member_id (Key3) — bigint — Foreign key → member.member_id — NOT NULL
- mission_id (Key2) — bigint — Foreign key → mission.mission_id — NOT NULL
- state (Field) — varchar2 — NOT NULL — ENUM(INPROGRESS, REQUESTING, COMPLETE)
- code (Field2) — bigint — NOT NULL
- created_at (Field3) — date — NOT NULL
member_terms (Untitled3)
- member_terms_id (Key) — bigint — Primary key — NOT NULL
- isAgree (Field) — boolean — NOT NULL
- terms_id (Key3) — varchar2 — Foreign key → terms.terms_id — NOT NULL
- member_id (Key2) — bigint — Foreign key → member.member_id — NOT NULL
mission (CopyOfUntitled3)
- mission_id (Key) — bigint — Primary key — NOT NULL
- content (Field) — varchar2 — NOT NULL
- reward (Field2) — bigint — NOT NULL
- deadline (Field3) — date — NOT NULL
- store_id (Key3) — bigint — Foreign key → store.store_id — NOT NULL
president (Untitled9)
- president_id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar2 — NOT NULL
- member_id (Key2) — bigint — Foreign key → member.member_id — NOT NULL
qna (Untitled6)
- qna_id (Key) — bigint — Primary key — NOT NULL
- content (Field) — varchar2 — NOT NULL
- title (Field2) — varchar2 — NOT NULL
- member_id (Key2) — bigint — Foreign key → member.member_id — NOT NULL
- type (Field3) — varchar2 — NOT NULL — ENUM(문의유형들,.,)
- state (Field4) — varchar2 — NOT NULL — ENUM(답변대기중, 답변완료)
qna_image (Untitled7)
- qna_image_id (Key) — bigint — Primary key — NOT NULL
- url (Field) — varchar2 — NOT NULL
- qna_id (Key2) — bigint — Foreign key → qna.qna_id — NOT NULL
region (CopyOfUntitled)
- region_id (Key) — bigint — Primary key — NOT NULL
- name (Field2) — varchar2 — NOT NULL
region_member (Untitled12)
- region_member_id (Key) — bigint — Primary key — NOT NULL
- state (Field) — bigint — NOT NULL
- region_id (Key2) — bigint — Foreign key → region.region_id — NOT NULL
- member_id (Key3) — bigint — Foreign key → member.member_id — NOT NULL
review (Untitled4)
- review_id (Key) — bigint — Primary key — NOT NULL
- rating (Field) — double — NOT NULL
- content (Field3) — varchar2 — NOT NULL
- date (Field2) — date — NOT NULL
- member_id (Key2) — bigint — Foreign key → member.member_id — NOT NULL
- store_id (Key3) — bigint — Foreign key → store.store_id — NOT NULL
review_image (Untitled5)
- review_image_id (Key) — bigint — Primary key — NOT NULL
- url (Field) — varchar2 — NOT NULL
- review_id (Key2) — bigint — Foreign key → review.review_id — NOT NULL
review_president (Untitled10)
- review_president_id (Key) — bigint — Primary key — NOT NULL
- content (Field) — varchar2 — NOT NULL
- date (Field2) — date — NOT NULL
- president_id (Key2) — bigint — Foreign key → president.president_id — NOT NULL
- review_id (Key3) — bigint — Foreign key → review.review_id — NOT NULL
store (CopyOfUntitled2)
- store_id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar2 — NOT NULL
- food_category_id (Key2) — bigint — Foreign key → food_category.food_category_id — NOT NULL
- address (Field2) — varchar2 — NOT NULL
- rating (Field3) — double — NOT NULL
- region_id (Key3) — bigint — Foreign key → region.region_id — NOT NULL
- president_id (Key4) — bigint — Foreign key → president.president_id — NOT NULL
- business_time_id (Key5) — bigint — Foreign key → business_time.business_time_id — NOT NULL
store_image (Untitled11)
- store_iamge_id (Key) — bigint — Primary key — NOT NULL
- url (Field) — varchar2 — NOT NULL
- store_id (Key2) — bigint — Foreign key → store.store_id — NOT NULL
terms (Untitled2)
- terms_id (Key) — varchar2 — Primary key — NOT NULL
- content (Field) — NOT NULL
- isEssential (Field2) — boolean — NOT NULL