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