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