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