경매톡_v2
테이블 (26)
auction_schedule
- id — bigint
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- date — date
- price — bigint
- result — varchar(255)
- round — int — NOT NULL
counsel
- id — bigint
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- counsel_date — date
- counsel_status — enum
- counsel_time — time(6)
- push_sent — bit — NOT NULL
- counsel_form_id — bigint
- counselor_id — bigint
- member_id — bigint
counsel_form
- id — bigint
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- area — varchar(255)
- interest — varchar(255)
- participant_type — varchar(255)
- purpose — varchar(255)
- service_type — varchar(255)
- member_id — bigint
counselor
- id — bigint
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- specialization — varchar(255)
- cell_phone — varchar(255)
- counsel_count — int — NOT NULL
- description — varchar(255)
- experience — int
- license — varchar(255)
- name — varchar(255)
counselor_image
- id — bigint
- url — varchar(255) — NOT NULL
- counselor_id — bigint
faq
- id — bigint
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- answer — varchar(250) — NOT NULL
- question — varchar(255) — NOT NULL
member
- id — bigint
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- birth — date
- cell_phone — varchar(255)
- client_id — varchar(255) — NOT NULL
- fcm_token — varchar(255)
- login_type — enum
- name — varchar(255)
- property_notification_enabled — bit — NOT NULL
- review_notification_enabled — bit — NOT NULL
- password — varchar(255)
- registered — bit — NOT NULL
- role — enum
- username — varchar(255)
- revenue_cat_app_user_id — varchar(255)
member_view_ticket_wallet
- id — bigint
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- balance — int — NOT NULL
- member_id — bigint — NOT NULL
notification
- id — bigint
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- body — varchar(255)
- content_id — bigint
- counsel_time — datetime(6)
- counselor_name — varchar(255)
- is_read — bit — NOT NULL
- property_name — varchar(255)
- thumbnail — varchar(255)
- title — varchar(255)
- type — enum
- member_id — bigint — NOT NULL
orders
- id — bigint
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- amount — bigint
- counselor_id — bigint
- idempotency_key — varchar(255)
- order_number — varchar(255)
- order_status — enum
- product_code — varchar(255)
- product_name — varchar(255)
- product_type — enum
- member_id — bigint — NOT NULL
- product_id — bigint — NOT NULL
payments
- id — bigint
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- acknowledged_at — datetime(6)
- approved_amount — bigint
- approved_at — datetime(6)
- failed_at — datetime(6)
- failure_code — varchar(255)
- failure_reason — varchar(255)
- payment_number — varchar(255)
- payment_provider — enum
- payment_status — enum
- provider_transaction_id — varchar(255)
- requested_amount — bigint
- sandbox — bit
- store — varchar(255)
- store_product_id — varchar(255)
- order_id — bigint — NOT NULL
product
- id — bigint
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- active — bit — NOT NULL
- description — varchar(255)
- name — varchar(255)
- original_price — bigint
- price — bigint
- product_type — enum
- recommended — bit — NOT NULL
- store_product_id — varchar(255)
product_component
- id — bigint
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- component_type — enum
- description — varchar(500)
- name — varchar(100) — NOT NULL
product_component_mapping
- id — bigint
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- quantity — int
- product_component_id — bigint — NOT NULL
- product_id — bigint — NOT NULL
property
- id — bigint
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- address — varchar(255)
- appraised_price — bigint
- area — int
- building_type — varchar(255)
- case_number — varchar(255)
- case_title — varchar(255)
- commencement_date — date
- court_name — varchar(255)
- creditor — varchar(255)
- debtor — varchar(255)
- expert_comment — varchar(255) — archar(255) nul
- is_purchased — bit — NOT NULL
- min_price — bigint
- name — varchar(255)
- owner — varchar(255)
- registration_date — date
- status — varchar(255)
- tenant — varchar(255)
- counselor_id — bigint
- member_id — bigint
- is_payment — bit — NOT NULL
property_auction_schedules
- property_id — bigint — NOT NULL
- auction_schedules_id — bigint — NOT NULL
property_image
- id — bigint
- url — varchar(255) — NOT NULL
- property_id — bigint
property_payment
- id — bigint
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- status — enum
- member_id — bigint
- property_id — bigint
qna
- id — bigint
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- category — enum — NOT NULL
- content — varchar(250) — NOT NULL
- status — enum — NOT NULL
- title — varchar(255) — NOT NULL
- member_id — bigint — NOT NULL
qna_answer
- id — bigint
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- content — varchar(250) — NOT NULL
- qna_id — bigint — NOT NULL
review
- id — bigint
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- content — varchar(255)
- score — int — NOT NULL
- counsel_id — bigint
- member_id — bigint
review_image
- id — bigint
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- url — varchar(255) — NOT NULL
- review_id — bigint
review_report
- id — bigint
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- content — varchar(255)
- report_type — tinyint
- member_id — bigint
- review_id — bigint
subscription
- id — bigint
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- end_date — datetime(6)
- start_date — datetime(6)
- subscription_status — enum — NOT NULL
- counselor_id — bigint — NOT NULL
- member_id — bigint — NOT NULL
subscriptions
- id — bigint
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- end_date — datetime(6)
- source_order_id — bigint
- start_date — datetime(6)
- subscription_status — enum — NOT NULL
- counselor_id — bigint — NOT NULL
- member_id — bigint — NOT NULL
- payment_id — bigint — NOT NULL
view_ticket_grant_histories
- id — bigint
- created_at — datetime(6)
- deleted_at — datetime(6)
- updated_at — datetime(6)
- quantity — int — NOT NULL
- order_id — bigint — NOT NULL
- product_component_id — bigint — NOT NULL