every ai
Tables (19)
board_community
- idx — bigint — Primary key — NOT NULL
- user_idx — bigint — 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 — 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 — 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
message
- idx — bigint — Primary key — NOT NULL
- user_idx — bigint — 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
- 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 — 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 — 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_bootpay
- idx — bigint — Primary key — NOT NULL
- payment_idx — bigint — 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 — 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
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 — NOT NULL
- image_file_idx — bigint
- video_file_idx — bigint
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
service_review
- idx — bigint — Primary key — NOT NULL
- work_service_idx — bigint — 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
- create_date — timestamp — NOT NULL
- update_date — timestamp
- delete_date — timestamp
service_review_reply
- idx — bigint — Primary key — NOT NULL
- service_review_idx — bigint — NOT NULL
- content — varchar(255) — 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 — 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