다 ERD

테이블 (19)

Category (Untitled10)

  • category_id (Key) — long — 기본 키 — NOT NULL
  • name (Field) — String — NOT NULL

Coupon (Untitled4)

  • coupon_id (Key) — long — 기본 키 — NOT NULL
  • shop_id (Key2) — long — 외래 키 → Shop.shop_id — NOT NULL
  • max_num (Field) — int — NOT NULL
  • Field2

File (Untitled15)

  • file_id (Key) — long — 기본 키 — NOT NULL
  • origin_name (Field) — String — NOT NULL
  • saved_name (Field2) — String — NOT NULL
  • size (Field3) — Long — NOT NULL
  • extension (Field4) — String — NOT NULL

Member (Untitled)

  • member_id (ID) — long — 기본 키 — NOT NULL
  • username (Field4) — String — NOT NULL
  • nickname (Field7) — String — NOT NULL
  • password (Field5) — String — NOT NULL
  • role (Field2) — String
  • tel (Field) — String — NOT NULL
  • created_date (Field3) — LocalDateTime — NOT NULL
  • modified_date (Field6) — LocalDateTime — NOT NULL

Menu (Untitled6)

  • munu_id (Key) — long — 기본 키 — NOT NULL
  • shop_id (Key2) — long — 외래 키 → Shop.shop_id — NOT NULL
  • file_id (Key3) — long — 외래 키 → File.file_id
  • name (Field) — String — NOT NULL
  • price (Field2) — long — NOT NULL
  • recommend (Field3) — Boolean — NOT NULL

Review_File (CopyOfUntitled16)

  • review_file_id (Key) — Long — 기본 키 — NOT NULL
  • review_id (Key2) — long — 외래 키 → review.review_id — NOT NULL
  • file_id (Key3) — long — 외래 키 → File.file_id — NOT NULL

Shop (Untitled2)

  • shop_id (Key) — long — 기본 키 — NOT NULL
  • member_id (ID) — long — 외래 키 → Member.member_id — NOT NULL
  • category_id (Key2) — long — 외래 키 → Category.category_id — NOT NULL
  • name (Field) — String — NOT NULL
  • tel (Field12) — String — NOT NULL
  • description (Field2) — String — NOT NULL
  • jehue_discount (Field13) — String — NOT NULL
  • jehue_coupon (Field9) — String — NOT NULL
  • jehue_service (Field10) — String — NOT NULL
  • loc_desc (Field3) — String — NOT NULL
  • latitude (Field4) — double — NOT NULL
  • longitude (Field5) — double — NOT NULL
  • is_premium (Field7) — boolean — NOT NULL
  • zzim_num (Field17) — int — NOT NULL
  • like_num (Field8) — int — NOT NULL
  • work_week (Field16) — String
  • start_time (Field6) — time — NOT NULL
  • end_time (Field11) — time — NOT NULL
  • created_date (Field14) — LocalDateTime — NOT NULL
  • modified_date (Field15) — LocalDateTime — NOT NULL

Shop_File (Untitled16)

  • shop_file_id (Key) — Long — 기본 키 — NOT NULL
  • shop_id (Key2) — long — 외래 키 → Shop.shop_id — NOT NULL
  • file_id (Key3) — long — 외래 키 → File.file_id — NOT NULL
  • description (Field) — String — NOT NULL

Student (CopyOfUntitled)

  • student_id (ID) — long — 기본 키 — NOT NULL
  • member_id (ID2) — long — 외래 키 → Member.member_id — NOT NULL
  • univ_id (Key) — long — 외래 키 → Univ.univ_id — NOT NULL
  • admission_year (Field) — long — NOT NULL
  • point (Field7) — long — NOT NULL
  • level (Field8) — int — NOT NULL
  • consent_receive (Field4) — Boolean — NOT NULL
  • crated_date (Field2) — LocalDateTime — NOT NULL
  • modified_date (Field3) — LocalDateTime — NOT NULL

Tag (Untitled11)

  • tag_id (Key) — long — 기본 키 — NOT NULL
  • name (Field) — String — NOT NULL
  • num (Field2) — Long — NOT NULL

Univ (Untitled3)

  • univ_id (Key) — long — 기본 키 — NOT NULL
  • name (Field) — String — NOT NULL

review (Untitled7)

  • review_id (Key2) — long — 기본 키 — NOT NULL
  • shop_id (Key) — long — 외래 키 → Shop.shop_id — NOT NULL
  • student_id (ID) — long — 외래 키 → Student.student_id — NOT NULL
  • content (Field3) — String — NOT NULL
  • like_num (Field) — long — NOT NULL
  • unlike_num (Field2) — long — NOT NULL
  • created_date (Field4) — LocalDateTime — NOT NULL
  • modified_date (Field5) — LocalDateTime — NOT NULL

review_tag (Untitled13)

  • review_tag_id (Key) — long — 기본 키 — NOT NULL
  • review_id (Key2) — long — 외래 키 → review.review_id — NOT NULL
  • tag_id (Key3) — long — 외래 키 → Tag.tag_id — NOT NULL

shop_tag (Untitled12)

  • shop_tag_id (Key) — long — 기본 키 — NOT NULL
  • shop_id (Key2) — long — 외래 키 → Shop.shop_id — NOT NULL
  • tag_id (Key3) — long — 외래 키 → Tag.tag_id — NOT NULL

shop_univ (Untitled5)

  • shop_univ_id (Key) — long — 기본 키 — NOT NULL
  • shop_id (Key2) — long — 외래 키 → Shop.shop_id — NOT NULL
  • univ_id (Key3) — long — 외래 키 → Univ.univ_id — NOT NULL

student_like_shop (Untitled9)

  • student_like_shop_id (Key) — long — 기본 키 — NOT NULL
  • student_id (ID) — long — 외래 키 → Student.student_id — NOT NULL
  • shop_id (Key2) — long — 외래 키 → Shop.shop_id — NOT NULL
  • created_date (Field) — LocalDateTime — NOT NULL

student_like_unlike_review (CopyOfUntitled9)

  • student_like_shop_id (Key) — long — 기본 키 — NOT NULL
  • student_id (ID) — long — 외래 키 → Student.student_id — NOT NULL
  • review_id (Key2) — long — 외래 키 → review.review_id — NOT NULL
  • created_date (Field) — LocalDateTime — NOT NULL

student_visit_shop (Untitled8)

  • student_visit_shop_id (Key2) — long — 기본 키 — NOT NULL
  • student_id (ID) — long — 외래 키 → Student.student_id — NOT NULL
  • shop_id (Key) — long — 외래 키 → Shop.shop_id — NOT NULL
  • visit_date (Field) — LocalDateTime — NOT NULL

zzim (Untitled14)

  • zzim_id (Key) — long — 기본 키 — NOT NULL
  • student_id (ID) — long — 외래 키 → Student.student_id — NOT NULL
  • shop_id (Key2) — long — 외래 키 → Shop.shop_id — NOT NULL
  • created_date (Field3) — LocalDateTime — NOT NULL