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