다 ERD

테이블 (18)

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
  • file_id (Key23) — long — 외래 키 — 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_desc (Field13) — String — NOT NULL
  • loc_desc (Field3) — String — NOT NULL
  • location_x (Field4) — double — NOT NULL
  • location_y (Field5) — double — NOT NULL
  • is_premium (Field7) — boolean — NOT NULL
  • like_num (Field8) — long — NOT NULL
  • unlike_num (Field10) — long — 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
  • description (Field) — String — NOT NULL
  • file_id (Key23) — long — 외래 키 — NOT NULL
  • student_file_id (Key223) — Long — 외래 키 — 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
  • file_id (Key22) — long — 외래 키 → Student_File.file_id — NOT NULL

Student_File (Untitled17)

  • file_id (Key2) — long — 외래 키 → File.file_id — NOT NULL
  • student_id (Field) — Long — NOT NULL
  • description (Field3) — String — NOT NULL

Tag (Untitled11)

  • tag_id (Key) — long — 기본 키 — NOT NULL
  • name (Field) — String — 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_unlike_shop (Untitled14)

  • student_unlike_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_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