다 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