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