123

Tables (30)

ADVERTISEMENT_ADMIN_BANNER

  • idx — bigint — 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 — 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 — 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 — 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 — 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 — 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 — Foreign key → BOARD_COMMUNITY_REPLY.idx
  • content — varchar(255) — NOT NULL
  • create_date — timestamp — NOT NULL
  • update_date — timestamp
  • delete_date — timestamp

FILE

  • idx — bigint — NOT NULL
  • type — varchar(255) — NOT NULL
  • create_date — timestamp — NOT NULL
  • update_date — timestamp
  • delete_date — timestamp

MESSAGE

  • idx — bigint — NOT NULL
  • user_idx — bigint — NOT NULL
  • message_room_idx — bigint — Foreign key → MESSAGE_ROOM.idx — NOT NULL
  • message_type — varchar(255) — NOT NULL
  • content — varchar(255)
  • read_date — timestamp
  • image_file_idx — bigint — Foreign key → FILE.idx
  • message_payment_request_idx — bigint
  • create_date — timestamp — NOT NULL
  • update_date — timestamp
  • delete_date — timestamp

MESSAGE_PAYMENT_REQUEST

  • idx — bigint — NOT NULL
  • work_service_idx — bigint — Foreign key → WORK_SERVICE.idx
  • description — varchar(255) — NOT NULL
  • create_date — timestamp — NOT NULL
  • update_date — timestamp
  • delete_date — timestamp

MESSAGE_ROOM

  • idx — bigint — NOT NULL
  • last_message_content — varchar(255) — NOT NULL
  • participant_first_idx — bigint — Foreign key → USER.idx — NOT NULL
  • participant_second_idx — bigint — Foreign key → USER.idx — NOT NULL
  • create_date — timestamp — NOT NULL
  • update_date — timestamp
  • delete_date — timestamp

MESSAGE_ROOM_BOOKMARK

  • idx — bigint — 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 — NOT NULL
  • user_idx — bigint — Foreign key → USER.idx — NOT NULL
  • type — varchar(255) — 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 — 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 — 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)
  • pg — varchar(255)
  • method — varchar(255)
  • 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 — 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 — 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 — NOT NULL
  • user_client_idx — bigint — Foreign key → USER.idx — NOT NULL
  • status — varchar(255) — 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 — varchar(255) — 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 — 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 — varchar(255) — NOT NULL
  • content — varchar(255) — NOT NULL
  • image_file_idx — bigint — Foreign key → FILE.idx — NOT NULL
  • status — varchar(255) — NOT NULL
  • create_date — timestamp — NOT NULL
  • update_date — timestamp
  • delete_date — timestamp

SERVICE

  • idx — bigint — NOT NULL
  • status — varchar(255) — NOT NULL
  • title — varchar(255) — NOT NULL
  • user_expert_idx — bigint — Foreign key → USER_EXPERT_INFO.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
  • create_date — timestamp — NOT NULL
  • update_date — timestamp
  • delete_date — timestamp

SERVICE_BOOKMARK

  • idx — bigint — 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 — NOT NULL
  • work_service_idx — bigint — Foreign key → 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
  • create_date — timestamp — NOT NULL
  • update_date — timestamp
  • delete_date — timestamp

SERVICE_REVIEW_REPLY

  • idx — bigint — 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 — NOT NULL
  • name — varchar(255) — NOT NULL
  • url — varchar(255) — NOT NULL
  • type — varchar(255) — 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 — 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 — varchar(255) — NOT NULL
  • login_type — varchar(255) — NOT NULL
  • create_date — timestamp — NOT NULL
  • update_date — timestamp
  • delete_date — timestamp

USER_BUSINESS

  • idx — bigint — NOT NULL
  • name — varchar(255) — NOT NULL
  • create_date — timestamp — NOT NULL
  • update_date — timestamp
  • delete_date — timestamp

USER_EXPERT_INFO

  • idx — bigint — NOT NULL
  • user_idx — bigint — Foreign key → USER.idx — NOT NULL
  • bank_code — varchar(255)
  • bank_account — varchar(255)
  • expert_level — varchar(255) — NOT NULL
  • create_date — timestamp — NOT NULL
  • update_date — timestamp
  • delete_date — timestamp

USER_JOB

  • idx — bigint — NOT NULL
  • name — varchar(255) — NOT NULL
  • create_date — timestamp — NOT NULL
  • update_date — timestamp
  • delete_date — timestamp

VACATION

  • idx — bigint — NOT NULL
  • user_expert_idx — bigint — 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 — NOT NULL
  • project_idx — bigint — Foreign key → PROJECT.idx — NOT NULL
  • user_expert_idx — bigint — Foreign key → 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 — NOT NULL
  • service_idx — bigint — Foreign key → SERVICE.idx — NOT NULL
  • user_expert_idx — bigint — Foreign key → 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