EVCARE
Tables (7)
agents (설계사)
- agentIndex — INT — Primary key — NOT NULL
- gaIndex — INT — Foreign key → gas.gaIndex — NOT NULL
- userid — VARCHAR
- name — CHAR
- tel — TYNYBLOB
- hash — TINYBLOB
- otpkey — TINYBLOB
- failcnt — INT
- role — INT
- accessip — CHAR
- createdAt — TIMESTAMP
- updatedAt
claims (청구)
- claimIndex — BIGINT — Primary key — NOT NULL
- request_id — CHAR — Primary key — NOT NULL
- agentIndex — INT — Foreign key → devices.agentIndex — NOT NULL
- serial_num — CHAR — Foreign key → devices.serial_num
- state — INT
- type — VARCHAR
- user_name — TINYBLOB
- user_jumin — TINYBLOB
- user_tel — TINYBLOB
- same_claim — TINYINT
- relation — VARCHAR
- is_child — TINYINT
- beneficiary_name — TINYBLOB
- beneficiary_jumin — TINYBLOB
- beneficiary_tel — TINYBLOB
- reason — TINYBLOB
- part — TINYBLOB
- part_id — INT
- acc_type — VARCHAR
- acc_date — DATE
- disease_name — VARCHAR
- bank — VARCHAR
- bank_id — INT
- account — TINYBLOB
- account_name — TINYBLOB
- job — CHAR
- job_claiment — CHAR
- image_cnt — INT
- noti — TINYINT
- nhisJoined — TINYINT
- evInfoThirdOfferAgr — TINYINT
devices (KIOSK)
- id (device_id) — INT — Primary key — NOT NULL
- serial_num — CHAR — Primary key
- agentIndex — INT — Foreign key → agents.agentIndex — NOT NULL
- partner_id — INT — Foreign key → partners.id — NOT NULL
- hospital_name — CHAR — Foreign key → partners.partner_name — NOT NULL
- gaIndex — INT — Foreign key → partners.gaIndex — NOT NULL
- device_name (Field3) — VARCHAR
- ver — CHAR
- type — JSON
gas (GA)
- gaIndex — INT — Primary key — NOT NULL
- name — CHAR
- desc
- rep — CHAR
- area — CHAR
- postArea — CHAR
- contract — TINYINT
- gaIndex (gaIndex2) — INT — Foreign key → gas.gaIndex — NOT NULL
images (IMAGE)
- index — BIGINT — Primary key — NOT NULL
- claimIndex — BIGINT — Foreign key → claims.claimIndex — NOT NULL
- org_name — VARCHAR
- saved_name — VARCHAR
insucos (INSUCO)
- index — BIGINT — Primary key — NOT NULL
- claimIndex — BIGINT — Foreign key → claims.claimIndex — NOT NULL
- company_id — INT
- state — INT
- usage — INT
- respCd — INT
- acpnNo — CHAR
- acpnImgNo — CHAR
- respMsg — VARCHAR
- fileInfo — JSON
- tryCnt — TINYINT
- memo — CHAR
partners (병원)
- id — INT — Primary key — NOT NULL
- partner_name — CHAR — Primary key — NOT NULL
- gaIndex — INT — Foreign key → gas.gaIndex — NOT NULL
- staff — CHAR
- tel — CHAR
- area — CHAR
- post_area — CHAR
- addr — VARCHAR