aibe5_2
pickasso project
테이블 (22)
Account (t_account)
- id (account_id) — Long — 기본 키 — NOT NULL
- username — String — NOT NULL — UNIQUE
- password — String — NOT NULL — use encoder
- role — Enum — NOT NULL
BasicInfo -> 상속용 서브테이블 (basic_info -> 상속용 서브테이블)
- id — Long — 기본 키 — NOT NULL — 가짜 id
- email — String — NOT NULL
- name — String — NOT NULL
- gender — Enum — NOT NULL
- phone — String — NOT NULL
- regTime (reg_time) — LocalDateTime — NOT NULL
- updateTime (update_time) — LocalDateTime — NOT NULL
- cache — Integer — NOT NULL
- deletedAt (deleted_at) — LocalDateTime
Career (t_career)
- id (career_id) — Long — 기본 키 — NOT NULL
- photographer (photographer_id) — Photographer — 외래 키 → Photograhper.id — NOT NULL
- name — String — NOT NULL
- startDate (start_date) — LocalDate — NOT NULL — 1일로 고정
- endDate (end_date) — LocalDate — 1일로 고정. null=now
CashHistory (t_cash_history)
- id (cash_history_id) — Long — 기본 키 — NOT NULL
- account (account_id) — Account — 외래 키 → Account.id — NOT NULL
- amount — Integer — NOT NULL
- balanceAfter (balance_after) — Integer — NOT NULL
- type — Enum — NOT NULL — 충전, 사용, 환불
- createdAt (created_at) — LocalDateTime — NOT NULL
- memo — String
Education (t_education)
- id (education_id) — Long — 기본 키 — NOT NULL
- photographer (photographer_id) — Photographer — 외래 키 → Photograhper.id — NOT NULL
- name — String — NOT NULL
- startDate (start_date) — LocalDate — NOT NULL — 1일로 고정
- endDate (end_date) — LocalDate — 1일로 고정. null=now
Item (t_item)
- id (item_id) — Long — 기본 키 — NOT NULL
- name — String — NOT NULL
- description — String — NOT NULL — Lob
- photographer (photographer_id) — Photographer — 외래 키 → Photograhper.id — NOT NULL
- region (region_id) — Region — 외래 키 → Region -> 상속용 서브테이블.id — NOT NULL
- reviewScore (review_score) — Long — NOT NULL
- reviewCount (review_count) — Integer — NOT NULL
- defaultPrice (default_price) — Integer — NOT NULL
- itemType (item_type) — Enum — NOT NULL
- tag (tag_id) — Tag — 외래 키 → Tag.id — NOT NULL
- itemState (item_state) — Enum — NOT NULL
- includes — String — Lob
- excludes — String — Lob
- thumbnailImgUrl (thumbnail_img_url) — String
- minBookingLeadTime (min_booking_Lead_time) — Integer — NOT NULL
- purchaseCount (purchase_count) — Integer — NOT NULL
- createdAt (created_at) — LocalDateTime — NOT NULL
ItemImg (item_img)
- id (item_img_id) — Long — 기본 키 — NOT NULL
- item (item_id) — Item — 외래 키 → Item.id — NOT NULL
- imgUrl (img_url) — String — NOT NULL
- imgOrder (img_order) — Integer — NOT NULL
ItemNotice (t_item_notice)
- id (item_notice_id) — Long — 기본 키 — NOT NULL
- item (item_id) — Item — 외래 키 → Item.id — NOT NULL
- noticeOrder (notice_order) — Integer — NOT NULL
- description — String — NOT NULL — Lob
Member (t_member)
- id (member_id) — Long — 외래 키 → Account.id — NOT NULL
- info (info_id) — BasicInfo — 외래 키 → BasicInfo -> 상속용 서브테이블.id — NOT NULL — 서브테이블
Order (t_order)
- id (order_id) — Long — 기본 키 — NOT NULL
- member (member_id) — Member — 외래 키 → Member.id — NOT NULL
- photographer (photographer_id) — Photographer — 외래 키 → Photograhper.id — NOT NULL
- region (region_id) — Region — 외래 키 → Region -> 상속용 서브테이블.id — NOT NULL — 서브테이블
- item (item_id) — Item — 외래 키 → Item.id — NOT NULL
- scheduledAt (scheduled_at) — LocalDateTime — NOT NULL
- requestedAt (requested_at) — LocalDateTime — NOT NULL
- decidedAt (decided_at) — LocalDateTime — NOT NULL
- totalPrice (total_price) — Integer — NOT NULL
- status — Enum — NOT NULL — 취소, 결제, 예약 등
- memo — String — max_length=500
Photograhper (t_photographer)
- id (photographer_id) — Long — 외래 키 → Account.id — NOT NULL
- info (info_id) — BasicInfo — 외래 키 → BasicInfo -> 상속용 서브테이블.id — NOT NULL — 서브테이블
PhotographerProfile (t_photographer_info)
- id (profile_id) — Long — 외래 키 → Photograhper.id — NOT NULL
- imgUrl (img_url) — String — NULL이면 default img
- nickname — String — NOT NULL
- intro — String — NOT NULL — Lob
- tools — Json — NOT NULL
- link — String
- verified — Boolean — NOT NULL
- purchaseCount (purchase_count) — Long — NOT NULL
- reviewScore (review_score) — Long — NOT NULL
- reviewCount (review_count) — Integer — NOT NULL
- contactableStartTime (contactable_start_time) — Integer — NOT NULL
- contactableEndTime (contactable_end_time) — Integer — NOT NULL
- responseTime (response_time) — Enum — NOT NULL
PhotographerTag (t_photographer_tag)
- id (photographer_tag_id) — Long — 기본 키 — NOT NULL
- tag (tag_id) — Tag — 외래 키 → Tag.id — NOT NULL
- photographer (photographer_id) — Photographer — 외래 키 → Photograhper.id — NOT NULL
Plan (t_plan)
- id (plan_id) — Long — 기본 키 — NOT NULL
- item (item_id) — Item — 외래 키 → Item.id — NOT NULL
- name — String
- price — Integer — NOT NULL
- planType (plan_type) — Enum — NOT NULL
- shootingDuration (shooting_duration) — Integer — NOT NULL
- originalPhotoCount (original_photo_count) — Integer — NOT NULL
- editedPhotoCount (edited_photo_count) — Integer — NOT NULL
- deliveryDays (delivery_days) — Integer — NOT NULL
Portfolio (t_portfolio)
- id (portfolio_id) — Long — 기본 키 — NOT NULL
- photographer (photographer_id) — Photographer — 외래 키 → Photograhper.id — NOT NULL
- name — String — NOT NULL
- projectType (project_type) — Enum — NOT NULL
- regTime (reg_time) — LocalDateTime — NOT NULL
- description — String — NOT NULL — Lob
- startDate (Field) — LocalDate — NOT NULL
- endDate (Field2) — LocalDate
PortfolioImg (portfolio_img)
- id (portfolio_img_id) — Long — 기본 키 — NOT NULL
- portfolio (portfolio_id) — Portfolio — 외래 키 → Portfolio.id — NOT NULL
- imgUrl (img_url) — String — NOT NULL
- imgOrder (img_order) — Integer — NOT NULL
PortfolioTag (t_portfolio_tag)
- id (portfolio_tag_id) — Long — 기본 키 — NOT NULL
- tag (tag_id) — Tag — 외래 키 → Tag.id — NOT NULL
- portfolio (portfolio_id) — Portfolio — 외래 키 → Portfolio.id — NOT NULL
Region -> 상속용 서브테이블 (region -> 상속용 서브테이블)
- id (region_id) — Long — 기본 키 — NOT NULL
- address — String — NOT NULL
- detailAddress (detail_address) — String — NOT NULL
- lat — Double — NOT NULL
- lng — Double — NOT NULL
Review (t_review)
- review (review_id) — Long — 외래 키 → Order.id — NOT NULL
- writer (member_id) — Member — 외래 키 → Member.id — NOT NULL
- photographer (photographer_id) — Photographer — 외래 키 → Photograhper.id — NOT NULL
- score — Integer — NOT NULL — * 100
- description — String — NOT NULL — Lob, min 10
ReviewImg (reviewImg)
- id (review_img_id) — Long — 기본 키 — NOT NULL
- review (review_id) — Review — 외래 키 → Review.review — NOT NULL
- imgUrl (img_url) — String — NOT NULL
- imgOrder (img_order) — Integer — NOT NULL
SavedLocation (t_savedlocation)
- id — Long — 기본 키 — NOT NULL
- member (member_id) — Member — 외래 키 → Member.id — NOT NULL
- name — String — NOT NULL
- region (region_id) — Region — 외래 키 → Region -> 상속용 서브테이블.id — NOT NULL — 서브테이블
Tag (t_tag)
- id (tag_id) — Long — 기본 키 — NOT NULL
- name — String — NOT NULL