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