유레카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