EVERY AI ERD
Tables (30)
advertisement_admin_banner
- idx — bigint — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- content — varchar(255) — NOT NULL
- thumbnail_file_idx — bigint — Foreign key → file.idx — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
advertisement_expert
- idx — bigint — Primary key — NOT NULL
- service_idx — bigint — Foreign key → service.idx — NOT NULL
- advertisement_expert_type_idx — bigint — Foreign key → advertisement_expert_type.idx — NOT NULL
- thumbnail_file_idx — bigint — Foreign key → file.idx — NOT NULL
- start_date — timestamp — NOT NULL
- end_date — timestamp — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
advertisement_expert_type
- idx — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- price — decimal — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
board_community
- idx — bigint — Primary key — NOT NULL
- user_idx — bigint — Foreign key → user.idx — NOT NULL
- title — varchar(255) — NOT NULL
- content — varchar(255) — NOT NULL
- view_count — bigint — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
board_community_recommendation
- idx — bigint — Primary key — NOT NULL
- user_idx — bigint — Foreign key → user.idx — NOT NULL
- board_community_idx — bigint — Foreign key → board_community.idx — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
board_community_reply
- idx — bigint — Primary key — NOT NULL
- user_idx — bigint — Foreign key → user.idx — NOT NULL
- board_community_idx — bigint — Foreign key → board_community.idx — NOT NULL
- parent_reply_idx — bigint
- content — varchar(255) — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
file
- idx — bigint — Primary key — NOT NULL
- type — enum('image', 'video', 'txt') — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
message
- idx — bigint — Primary key — NOT NULL
- user_idx — bigint — Foreign key → user.idx — NOT NULL
- message_room_idx — bigint — Foreign key → message_room.idx — NOT NULL
- message_type — enum('normal', 'image', 'payment') — NOT NULL
- content — varchar(255)
- image_file_idx — bigint — Foreign key → file.idx
- message_payment_request_idx — bigint — Foreign key → message_payment_request.idx
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
message_payment_request
- idx — bigint — Primary key — NOT NULL
- work_idx — bigint
- description — varchar(255) — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
message_room
- idx — bigint — Primary key — NOT NULL
- last_message_content — varchar(255) — NOT NULL
- participant_first_idx — bigint — NOT NULL
- participant_second_idx — bigint — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
message_room_bookmark
- idx — bigint — Primary key — NOT NULL
- user_idx — bigint — Foreign key → user.idx — NOT NULL
- message_room_idx — bigint — Foreign key → message_room.idx — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
notification
- idx — bigint — Primary key — NOT NULL
- user_idx — bigint — Foreign key → user.idx — NOT NULL
- type — enum('product', 'ea') — NOT NULL
- content — varchar(255) — NOT NULL
- json_data — varchar(255) — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
payment
- idx — bigint — Primary key — NOT NULL
- status — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- method — varchar(255) — NOT NULL
- price — decimal — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
payment_bootpay
- idx — bigint — Primary key — NOT NULL
- payment_idx — bigint — Foreign key → payment.idx — NOT NULL
- receipt_id — varchar(255) — NOT NULL
- order_id — bigint
- price — decimal — NOT NULL
- currency — varchar(255) — NOT NULL
- pg — varchar(255) — NOT NULL
- method — varchar(255) — NOT NULL
- all_data — varchar(255)
- requested_at — timestamp — NOT NULL
- purchased_at — timestamp — NOT NULL
- receipt_url — varchar(255)
- status — varchar(255)
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
product_category
- idx — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- image_file_idx — bigint — Foreign key → file.idx — NOT NULL
- sequence — bigint — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
product_subcategory
- idx — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- product_category_idx — bigint — Foreign key → product_category.idx — NOT NULL
- sequence — bigint — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
project
- idx — bigint — Primary key — NOT NULL
- user_client_idx — bigint — Foreign key → user.idx — NOT NULL
- status — enum('wait', 'rewait', 'confirm', 'stop') — NOT NULL
- title — varchar(255) — NOT NULL
- product_category_idx — bigint — Foreign key → product_category.idx — NOT NULL
- product_subcategory_idx — bigint — Foreign key → product_subcategory.idx — NOT NULL
- description — varchar(255) — NOT NULL
- price — decimal — NOT NULL
- project_preparation — enum('구상만 있음', '기획서 있음', '시안 있음') — NOT NULL
- work_day — bigint — NOT NULL
- thumbnail_file_idx — bigint — Foreign key → file.idx — NOT NULL
- image_file_idx — bigint — Foreign key → file.idx — NOT NULL
- end_date — timestamp — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
report
- idx — bigint — Primary key — NOT NULL
- user_idx — bigint — Foreign key → user.idx — NOT NULL
- user_reported_idx — bigint — Foreign key → user.idx
- board_community_idx — bigint — Foreign key → board_community.idx
- report_type — enum('게시물', '전문가', '의뢰인') — NOT NULL
- content — varchar(255) — NOT NULL
- image_file_idx — bigint — Foreign key → file.idx — NOT NULL
- status — enum('accept', 'complete') — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
service
- idx — bigint — Primary key — NOT NULL
- status — enum('wait', 'reject', 'approval', 'vacation') — NOT NULL
- title — varchar(255) — NOT NULL
- user_expert_idx — bigint — Foreign key → user_expert_info.user_idx — NOT NULL
- product_category_idx — bigint — Foreign key → product_category.idx — NOT NULL
- product_subcategory_idx — bigint — Foreign key → product_subcategory.idx — NOT NULL
- detail_title — varchar(255) — NOT NULL
- description — varchar(255) — NOT NULL
- price — decimal — NOT NULL
- work_day — int — NOT NULL
- update_count — int — NOT NULL
- thumbnail_file_idx — bigint — Foreign key → file.idx — NOT NULL
- image_file_idx — bigint — Foreign key → file.idx
- video_file_idx — bigint — Foreign key → file.idx
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
service_bookmark
- idx — bigint — Primary key — NOT NULL
- user_client_idx — bigint — Foreign key → user.idx — NOT NULL
- service_idx — bigint — Foreign key → service.idx — NOT NULL
- create_date — timestamp — NOT NULL
service_review
- idx — bigint — Primary key — NOT NULL
- work_service_idx — bigint — Foreign key → work_service.idx — NOT NULL
- satisfaction — decimal — NOT NULL
- conseling — decimal — NOT NULL
- fast_response — decimal — NOT NULL
- everage_rating — decimal — NOT NULL
- content — varchar(255) — NOT NULL
- image_file_idx — bigint — Foreign key → file.idx
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
service_review_reply
- idx — bigint — Primary key — NOT NULL
- service_review_idx — bigint — Foreign key → service_review.idx — NOT NULL
- content — varchar(255) — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
sub_file
- idx — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- url — varchar(255) — NOT NULL
- type — enum('service', 'message') — NOT NULL
- file_idx — bigint — Foreign key → file.idx — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
user
- idx — bigint — Primary key — NOT NULL
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- nickname — varchar(255) — NOT NULL
- name — varchar(255)
- introduction — varchar(255)
- phone — varchar(255)
- is_agree_marketing — boolean — NOT NULL
- is_active_over_year — boolean — NOT NULL
- active_over_year_time — timestamp
- job_idx — bigint — Foreign key → user_job.idx — NOT NULL
- business_idx — bigint — Foreign key → user_business.idx — NOT NULL
- file_profile_idx — bigint — Foreign key → file.idx — NOT NULL
- role — enum('client', 'expert', 'admin') — NOT NULL
- login_type — enum('kakao', 'naver', 'google', 'ea') — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
user_business
- idx — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
user_expert_info
- idx — bigint — Primary key — NOT NULL
- user_idx — bigint — Foreign key → user.idx — NOT NULL
- bank_code — varchar(255)
- bank_account — varchar(255)
- vacation_idx — bigint — Foreign key → vacation.idx
- expert_level — varchar(255) — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
user_job
- idx — bigint — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
vacation
- idx — bigint — Primary key — NOT NULL
- user_expert_idx — bigint — Foreign key → user_expert_info.idx — NOT NULL
- vacation_day — varchar(255) — NOT NULL
- vacation_reason — varchar(255) — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
work_project
- idx — bigint — Primary key — NOT NULL
- project_idx — bigint — Foreign key → project.idx — NOT NULL
- user_expert_idx — bigint — Foreign key → user_expert_info.user_idx — NOT NULL
- user_client_idx — bigint — Foreign key → user.idx — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
work_service
- idx — bigint — Primary key — NOT NULL
- service_idx — bigint — Foreign key → service.idx — NOT NULL
- user_expert_idx — bigint — Foreign key → user_expert_info.user_idx — NOT NULL
- user_client_idx — bigint — Foreign key → user.idx — NOT NULL
- price — decimal — NOT NULL
- work_day — bigint — NOT NULL
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp