ANT

Tables (5)

betseniorcare (Untitled3)

  • conno (Key) — Long — Primary key — NOT NULL
  • seniorno (Field) — LONG
  • careno (Field2) — LONG
  • month (Field3) — INTEGER
  • year (Field4) — INTEGER
  • regdate (Field5) — timestamp
  • stateck (Field6) — INTEGER

caregiver (Untitled2)

  • careno (Key) — LONG — Primary key — NOT NULL
  • conno (Key2) — Long — Foreign key → betseniorcare.conno — NOT NULL
  • name (이름) — VARCHAR
  • birth (Field2) — VARCHAR
  • gender (Field3) — INTEGER
  • tel (Field4) — VARCHAR
  • address (Field5) — VARCHAR
  • profile (Field6) — VARCHAR
  • worktime (Field7) — VARCHAR
  • char1 (Field8) — VARCHAR
  • char2 (Field9) — VARCHAR
  • char3 (Field10) — VARCHAR
  • info (Field11) — VARCHAR
  • visittime (Field12) — VARCHAR
  • exp (Field13) — VARCHAR
  • certifi (Field14) — VARCHAR
  • good (Field15) — VARCHAR
  • goal (Field16) — VARCHAR
  • lon (Field17) — decimal
  • lati (Field18) — decimal
  • regdate (Field) — timestamp
  • cid (Field19) — VARCHAR
  • pwd (Field20) — VARCHAR
  • workday (Field21) — VARCHAR
  • regcheck (Field22) — Integer
  • certiImage (Field23) — VARCHAR
  • roles (Field24) — VARCHAR

sadmin (Untitled5)

  • adminno (Key) — LONG — Primary key — NOT NULL
  • aid (Field) — VARCHAR
  • pwd (Field2) — VARCHAR
  • roles (Field3) — VARCHAR

searched (Untitled4)

  • searchno (Key) — LONG — Primary key — NOT NULL
  • seniorno (Key2) — LONG — Foreign key → senior.seniorno — NOT NULL
  • conno (Key22) — Long — Foreign key → senior.conno — NOT NULL
  • searchedadr (Field) — VARCHAR
  • seniorno (Field2) — LONG
  • regdate (Field3) — timestamp
  • lon (Field4) — decimal
  • lati (Field5) — decimal

senior (Untitled)

  • seniorno (Key) — LONG — Primary key — NOT NULL
  • conno (Key2) — Long — Foreign key → betseniorcare.conno — NOT NULL
  • name (Field) — VARCHAR
  • birth (Field2) — VARCHAR
  • gender (Field3) — INTEGER
  • tel (Field4) — VARCHAR
  • telcare (Field5) — VARCHAR
  • address (Field6) — VARCHAR
  • lon (Field7) — decimal
  • lati (Field8) — decimal
  • regdate (Field9) — Timestamp
  • spec1 (Field10) — VARCHAR
  • spec2 (Field11) — VARCHAR
  • spec3 (Field12) — VARCHAR
  • sid (Field13) — VARCHAR
  • pwd (Field14) — VARCHAR
  • roles (Field15) — VARCHAR