admin_web
Tables (27)
contract
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- contract_datetime — datetime(6)
- deposit — decimal(32,14)
- description — varchar(255)
- end_datetime — datetime(6)
- start_datetime — datetime(6)
- type — varchar(255)
- contact_rep_id — bigint(20) — Foreign key → customer_member.id — NOT NULL
- contract_rep_id — bigint(20) — Foreign key → customer_member.id — NOT NULL
- customer_id — bigint(20) — Foreign key → customer.id — NOT NULL
- manager_id — bigint(20) — Foreign key → manager.id — NOT NULL
- digital_signature_id — bigint(20) — Foreign key → digital_signature.id
- rent_price — decimal(32,14)
- next_payment_date — datetime(6)
- status — varchar(255)
- billing_key_id — bigint(20) — Foreign key → payment_method.id
contract_office
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- description — varchar(2048)
- contract_id — bigint(20) — Foreign key → contract.id — NOT NULL
- office_id — bigint(20) — Foreign key → office.id — NOT NULL
customer
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- company_registration_number — varchar(16)
- description — varchar(2048)
- name — varchar(256)
- registration_number — varchar(16)
- status — varchar(255)
- type — varchar(255)
- service_provider_id — bigint(20) — Foreign key → service_provider.id — NOT NULL
customer_account
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- name — varchar(255)
customer_member
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- birthday — date
- email — varchar(256) — NOT NULL
- gender — varchar(255)
- is_init_password — bit(1)
- is_withdrawal_blocked — bit(1)
- last_login_date — datetime(6)
- member_status — varchar(255)
- name — varchar(256) — NOT NULL
- nickname — varchar(24)
- password — varchar(100)
- phone_number — varchar(16)
- role — varchar(255) — NOT NULL
- description — varchar(2048)
- status — varchar(255)
- type — varchar(255)
- customer_id — bigint(20) — Foreign key → customer.id — NOT NULL
digital_signature
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- req_allow_simple_regist_yn — bit(1) — NOT NULL
- req_app_use_yn — bit(1) — NOT NULL
- req_call_center_name — varchar(256)
- req_call_center_num — varchar(256)
- req_expires_in — int(11)
- req_receiver_birth_day — date
- req_receiver_hp — varchar(256)
- req_receiver_name — varchar(256)
- req_sub_client_id — varchar(256)
- req_tms_message — varchar(2048)
- req_tms_title — varchar(256)
- req_token — varchar(2048)
- req_verify_nameyn — bit(1) — NOT NULL
- res_client_name — varchar(256)
- res_complete_dt — varchar(16)
- res_expire_dt — varchar(16)
- res_expires_in — int(11)
- res_receipt_id — varchar(256)
- res_reg_dt — varchar(16)
- res_request_dt — varchar(16)
- res_signed_data — varchar(4096)
- res_status — int(11)
- res_sub_client_name — varchar(256)
- res_tx_id — varchar(256)
- res_verify_dt — varchar(16)
- res_view_dt — varchar(16)
event
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- content — varchar(2048)
- end_datetime — datetime(6)
- start_datetime — datetime(6)
- thumbnail — varchar(256)
- title — varchar(256)
- type — varchar(255)
- office_branch_id — bigint(20) — Foreign key → office_branch.id
- service_provider_id — bigint(20) — Foreign key → service_provider.id — NOT NULL
- image_url — varchar(256)
gate
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- description — varchar(2048)
- device_id — int(11)
- device_ip — varchar(16)
- device_port — int(11)
- is_opened — bit(1)
- office_id — bigint(20) — Foreign key → office.id — NOT NULL
gate_access_log
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- code — varchar(255)
- date_time — datetime(6)
- type — varchar(255)
- credential_id — bigint(20) — Foreign key → gate_credential.id — NOT NULL
gate_credential
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- csn_card_data — bigint(20)
- end_time — datetime(6)
- status — varchar(255)
- type — varchar(255)
- customer_member_id — bigint(20) — Foreign key → customer_member.id — NOT NULL
- gate_id — bigint(20) — Foreign key → gate.id — NOT NULL
guide
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- content — varchar(2048)
- title — varchar(256)
- type — varchar(255)
- office_branch_id — bigint(20) — Foreign key → office_branch.id
- service_provider_id — bigint(20) — Foreign key → service_provider.id — NOT NULL
log_message
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- channel — varchar(255) — NOT NULL
- content — varchar(2048) — NOT NULL
- is_read — bit(1)
- is_send_message — bit(1)
- link_id — bigint(20)
- message_deep_link_target — varchar(255)
- message_id — bigint(20)
- phone_number — varchar(24)
- status — varchar(255)
- title — varchar(255)
- type — varchar(255) — NOT NULL
- contract_id — bigint(20) — Foreign key → contract.id
- customer_member_id — bigint(20) — Foreign key → customer_member.id
log_payment
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- date_time — datetime(6)
- message — varchar(2048)
- res_code — varchar(16)
- type — varchar(255) — NOT NULL
- payment_method_id — bigint(20) — Foreign key → payment_method.id
- code — varchar(16)
manager
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- birthday — date
- email — varchar(256) — NOT NULL
- gender — varchar(255)
- is_init_password — bit(1)
- is_withdrawal_blocked — bit(1)
- last_login_date — datetime(6)
- member_status — varchar(255)
- name — varchar(256) — NOT NULL
- nickname — varchar(24)
- password — varchar(100)
- phone_number — varchar(16)
- role — varchar(255) — NOT NULL
- effective_date — datetime(6)
- employee_type — varchar(255)
- expire_date — datetime(6)
- job — varchar(255)
- service_provider_id — bigint(20) — Foreign key → service_provider.id — NOT NULL
manager_branch
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- role — varchar(255)
- manager_id — bigint(20) — Foreign key → manager.id — NOT NULL
- office_branch_id — bigint(20) — Foreign key → office_branch.id — NOT NULL
- manager_branch_id — bigint(20) — Foreign key → manager.id
notice
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- content — varchar(2048)
- thumbnail — varchar(256)
- title — varchar(256)
- office_branch_id — bigint(20) — Foreign key → office_branch.id
- service_provider_id — bigint(20) — Foreign key → service_provider.id — NOT NULL
- image_url — varchar(256)
office
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- capacity — int(11) — NOT NULL
- description — varchar(255)
- name — varchar(256)
- type — varchar(255)
- office_branch_id — bigint(20) — Foreign key → office_branch.id — NOT NULL
- image_url — varchar(256)
office_branch
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- latitude — decimal(17,14)
- location — varchar(2048)
- longitude — decimal(17,14)
- name — varchar(256)
- service_provider_id — bigint(20) — Foreign key → service_provider.id — NOT NULL
- map_url — varchar(2048)
office_price
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- deposit — decimal(32,14)
- promotion_type — varchar(255)
- rent — decimal(32,14)
- type — varchar(255)
- office_id — bigint(20) — Foreign key → office.id — NOT NULL
- rent_price — decimal(32,14)
office_tour
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- description — varchar(2048)
- end_datetime — datetime(6)
- start_datetime — datetime(6)
- customer_member_id — bigint(20) — Foreign key → customer_member.id — NOT NULL
- office_branch_id — bigint(20) — Foreign key → office_branch.id — NOT NULL
payment_details
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- approval_no — varchar(256)
- cancelled_price — decimal(32,14)
- cancelled_tax_free — decimal(32,14)
- price — decimal(32,14)
- tax_free — decimal(32,14)
- contract_id — bigint(20) — Foreign key → contract.id — NOT NULL
- payment_method_id — bigint(20) — Foreign key → payment_method.id — NOT NULL
- approval_number — varchar(255)
- description — varchar(2048)
- receipt_url — varchar(255)
- status — varchar(255) — NOT NULL
payment_method
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- credit_card_company — varchar(255) — NOT NULL
- expired_datetime — datetime(6)
- method_number — varchar(255)
- pg_company — varchar(255) — NOT NULL
- token — varchar(255)
- type — varchar(255) — NOT NULL
sensor
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- description — varchar(2048)
- hejhome_id — varchar(256)
- measure_interval — int(11)
- model_name — varchar(256)
- name — varchar(256)
- token — varchar(256)
- type — varchar(255)
- value_unit — varchar(255)
- office_id — bigint(20) — Foreign key → office.id — NOT NULL
sensor_value
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- date_time — datetime(6)
- measure_value — double
- sensor_id — bigint(20) — Foreign key → sensor.id — NOT NULL
service_provider
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- company_registration_number — varchar(16)
- hejhome_token — varchar(2048)
- name — varchar(256)
- registration_number — varchar(16)
- bank_account — varchar(16)
tax_bill
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- issued_date — datetime(6)
- status — varchar(255)
- sub_total — decimal(32,14)
- tax — decimal(32,14)
- total — decimal(32,14)
- contract_id — bigint(20) — Foreign key → contract.id — NOT NULL
token
- id — bigint(20) — Primary key — NOT NULL
- created_by — varchar(255)
- created_date — datetime(6)
- is_deleted — bit(1)
- last_modified_by — varchar(255)
- last_modified_date — datetime(6)
- access_token — varchar(256)
- refresh_token — varchar(256)
- username — varchar(255)
- customer_member_id — bigint(20) — Foreign key → customer_member.id
- manager_id — bigint(20) — Foreign key → manager.id