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