유레카SW교육_댕꾸_ERD

테이블 (26)

CopyOfCopyOfCopyOfUntitled

  • admin_id — VARCHAR(20) — 기본 키 — NOT NULL
  • authority — VARCHAR(20)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

CopyOfCopyOfUntitled2

  • Key — VARCHAR(255) — 기본 키 — NOT NULL
  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)
  • Field3 — VARCHAR(255)

CopyOfUntitled2

  • Field — VARCHAR(255)
  • Field2 — VARCHAR(255)

Untitled8

  • Key — VARCHAR(255) — 기본 키 — NOT NULL
  • Key2 — VARCHAR(255) — 외래 키 → designer.designer_id — NOT NULL

bookmark

  • bookmark_id — BIGINT — 기본 키 — NOT NULL
  • customer_id — BIGINT — 외래 키 → customer.customer_id — NOT NULL
  • designer_id — BIGINT — 외래 키 → designer.designer_id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

breeds

  • possible_id — BIGINT — 기본 키 — NOT NULL
  • designer_id — BIGINT — 외래 키 → designer.designer_id — NOT NULL
  • possible_major_breed_code — VARCHAR(20) — NOT NULL
  • possible_sub_breed_code — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

certificate

  • certificate_id — BIGINT — 기본 키 — NOT NULL
  • designer_id — BIGINT — 외래 키 → designer.designer_id — NOT NULL
  • img_url — VARCHAR(300)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

common_code

  • code_id — VARCHAR(20) — 기본 키 — NOT NULL
  • code_nm — VARCHAR(20)
  • code_desc — VARCHAR(100)

customer

  • customer_id — BIGINT — 기본 키 — NOT NULL
  • customer_loginId — VARCHAR(50) — NOT NULL
  • email — VARCHAR(50) — NOT NULL
  • password — VARCHAR(200) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • customer_name — VARCHAR(20) — NOT NULL
  • birthdate — DATE — NOT NULL
  • gender — VARCHAR(4) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • address1 — VARCHAR(50) — NOT NULL
  • address2 — VARCHAR(50) — NOT NULL
  • detail_address — VARCHAR(50)
  • info_agree — VARCHAR(4) — NOT NULL
  • customer_img_url — VARCHAR(300) — NOT NULL
  • customer_img_name — VARCHAR(50) — NOT NULL
  • x_position — FLOAT — NOT NULL
  • y_position — FLOAT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

designer

  • designer_id — BIGINT — 기본 키 — NOT NULL
  • designer_login_id — VARCHAR(50) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(200) — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • designer_name — VARCHAR(50) — NOT NULL
  • official_name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • join_date — DATETIME — NOT NULL
  • billing_code — VARCHAR(50) — NOT NULL
  • is_monthly_pay — VARCHAR(4) — NOT NULL
  • monthly_pay_date — DATETIME — NOT NULL
  • designer_img_url — VARCHAR(300) — NOT NULL
  • designer_img_name — VARCHAR(100) — NOT NULL
  • address1 — VARCHAR(50) — NOT NULL
  • address2 — VARCHAR(50) — NOT NULL
  • detail_address — VARCHAR(50)
  • introduction — VARCHAR(300)
  • work_experience — VARCHAR(100)
  • is_verified — VARCHAR(4) — NOT NULL
  • business_number — VARCHAR(50)
  • businessIs_verified — VARCHAR(4) — NOT NULL
  • x_position — FLOAT — NOT NULL
  • y_position — FLOAT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

estimate

  • estimate_id — BIGINT — 기본 키 — NOT NULL
  • designer_id — BIGINT — 외래 키 → designer.designer_id — NOT NULL
  • request_id — BIGINT — 외래 키 → request.request_id — NOT NULL
  • estimate_detail — VARCHAR(200) — NOT NULL
  • desired_date — DATETIME
  • estimate_payment — DECIMAL(10, 2)
  • estimate_status — VARCHAR(20)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

estimate_image

  • review_img_id — BIGINT — 기본 키 — NOT NULL
  • estimate_id — BIGINT — 외래 키 → estimate.estimate_id — NOT NULL
  • estimate_img_url — VARCHAR(300) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

guardian

  • guardian_id — BIGINT — 기본 키 — NOT NULL
  • guardian_name — VARCHAR(100) — NOT NULL
  • vehicle — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

pet

  • pet_id — BIGINT — 기본 키 — NOT NULL
  • customer_id — BIGINT — 외래 키 → customer.customer_id — NOT NULL
  • pet_name — VARCHAR(50) — NOT NULL
  • birth_date — DATE — NOT NULL
  • gender — VARCHAR(4) — NOT NULL
  • major_breed_code — VARCHAR(20) — NOT NULL
  • sub_breed_code — VARCHAR(20) — NOT NULL
  • weight — DOUBLE — NOT NULL
  • special_notes — VARCHAR(300)
  • petImg_url — VARCHAR(300) — NOT NULL
  • petImg_name — VARCHAR(50) — NOT NULL
  • is_neutered — VARCHAR(4) — NOT NULL

portfolio

  • portfolio_id — BIGINT — 기본 키 — NOT NULL
  • designer_id — BIGINT — 외래 키 → designer.designer_id — NOT NULL
  • video_id — BIGINT
  • video_url — VARCHAR(300)
  • video_name — VARCHAR(100)
  • title — VARCHAR(100)
  • contents — VARCHAR(300)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

portfolio_img

  • image_id — BIGINT — 기본 키 — NOT NULL
  • portfolio_id — BIGINT — 외래 키 → portfolio.portfolio_id — NOT NULL
  • img_url — VARCHAR(300)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

process

  • process_id — BIGINT — 기본 키 — NOT NULL
  • reservation_id — BIGINT — 외래 키 → reservation.reservation_id — NOT NULL
  • guardian_id — BIGINT — 외래 키 → guardian.guardian_id
  • process_status — VARCHAR(20)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

request

  • request_id — BIGINT — 기본 키 — NOT NULL
  • pet_id — BIGINT — 외래 키 → pet.pet_id — NOT NULL
  • customer_id — BIGINT — 외래 키 → customer.customer_id — NOT NULL
  • desired_service_code — VARCHAR(20) — NOT NULL
  • last_grooming_date — VARCHAR(20) — NOT NULL
  • desired_date1 — DATETIME — NOT NULL
  • desired_date2 — DATETIME
  • desired_date3 — DATETIME
  • desired_region — VARCHAR(50) — NOT NULL
  • id_delivery — BOOLEAN — NOT NULL
  • is_monitoringIncluded — BOOLEAN — NOT NULL
  • additional_request — VARCHAR(100)
  • request_status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

reservation

  • reservation_id — BIGINT — 기본 키 — NOT NULL
  • request_id — BIGINT — 외래 키 → request.request_id
  • estimate_id — BIGINT — 외래 키 → estimate.estimate_id
  • pet_id — BIGINT — 외래 키 → pet.pet_id — NOT NULL
  • designer_id — BIGINT — 외래 키 → designer.designer_id — NOT NULL
  • reservation_type — VARCHAR(20) — NOT NULL
  • is_finished — BOOLEAN — NOT NULL
  • is_canceled — BOOLEAN — NOT NULL
  • reservation_date — DATE — NOT NULL
  • start_time — TIME — NOT NULL
  • end_time — TIME — NOT NULL
  • grooming_fee — DECIMAL(10, 2) — NOT NULL
  • delivery_fee — DECIMAL(10, 2)
  • monitoring_fee — DECIMAL(10, 2)
  • total_payment — DECIMAL(10, 2) — NOT NULL
  • desired_service — VARCHAR(20)
  • last_grooming_date — VARCHAR(20)
  • is_delivery — BOOLEAN
  • is_monitoring — BOOLEAN
  • additional_request — VARCHAR(100)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

reservationPayment

  • payment_id — VARCHAR(255) — 기본 키 — NOT NULL
  • reservation_id — VARCHAR(255) — 외래 키 → reservation.reservation_id — NOT NULL
  • payment_method — VARCHAR(255)
  • amount — VARCHAR(255)
  • payment_request_time — VARCHAR(255)

reservationPaymentHistory

  • Key — VARCHAR(255) — 기본 키 — NOT NULL
  • Field — VARCHAR(255)

review

  • review_id — BIGINT — 기본 키 — NOT NULL
  • review_contents — VARCHAR(200)
  • review_star — INT — NOT NULL
  • isFeed_add — BOOLEAN — NOT NULL
  • feed_url — VARCHAR(300)
  • review_like_cnt — INT — NOT NULL
  • designer_id — BIGINT — 외래 키 → designer.designer_id — NOT NULL
  • customer_id — BIGINT — 외래 키 → customer.customer_id — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

review_image

  • review_img_id — BIGINT — 기본 키 — NOT NULL
  • review_id — BIGINT — 외래 키 → review.review_id — NOT NULL
  • review_img_url — VARCHAR(300) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

review_like

  • review_like_id — BIGINT — 기본 키 — NOT NULL
  • review_id — BIGINT — 외래 키 → review.review_id — NOT NULL
  • user_id — BIGINT — NOT NULL
  • user_type — VARCHAR(20) — NOT NULL
  • is_review_like — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

services

  • service_id — BIGINT — 기본 키 — NOT NULL
  • designer_id — BIGINT — 외래 키 → designer.designer_id — NOT NULL
  • provided_services_code — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

streaming

  • streaming_id — BIGINT — 기본 키 — NOT NULL
  • process_id — BIGINT — 외래 키 → process.process_id — NOT NULL
  • sender_id — BIGINT — NOT NULL
  • receiver_id — BIGINT — NOT NULL
  • start_date — DATETIME — NOT NULL
  • end_date — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME