butakcare
Tables (15)
HTE_CAREGIVER
- RN_ — INTEGER — Primary key — NOT NULL
- BIRTH — DATE
- CAREER_START — DATE
- HAS_CAR — BOOLEAN
- HAS_DEMENTIA_TRAINING — BOOLEAN
- ID — BIGINT
- DTYPE — CHARACTER — NOT NULL
- ADDRESS — CHARACTER
- ADDRESS_DETAIL — CHARACTER
- CAREER_DESCRIPTION — CHARACTER
- CAREGIVER_LICENSE — CHARACTER
- GENDER — CHARACTER
- NAME — CHARACTER
- NURSING_ASSISTANT_LICENSE — CHARACTER
- PASSWORD — CHARACTER
- PHONE_NUMBER — CHARACTER
- PHOTO — CHARACTER
- SOCIAL_WORKER_LICENSE — CHARACTER
- USERNAME — CHARACTER
HTE_CAREGIVER_CONDITION
- RN_ — INTEGER — Primary key — NOT NULL
- HAS_CAR — BOOLEAN
- HAS_DEMENTIA_TRAINING — BOOLEAN
- MAX_WAGE — INTEGER
- MIN_WAGE — INTEGER
- CAREGIVER_ID — BIGINT
- ID — BIGINT
- UPDATED_TIME — TIMESTAMP(6)
- GENDER — CHARACTER
HTE_CAREGIVER_CONDITION_REGION
- RN_ — INTEGER — Primary key — NOT NULL
- CAREGIVER_CONDITION_ID — BIGINT
- ID — BIGINT
- REGION_REGION_ID — CHARACTER
HTE_CAREGIVER_CONDITION_TIME
- RN_ — INTEGER — Primary key — NOT NULL
- END_TIME — TIME(6)
- START_TIME — TIME(6)
- CAREGIVER_CONDITION_ID — BIGINT
- ID — BIGINT
- WEEKDAY — CHARACTER
HTE_CENTER
- RN_ — INTEGER — Primary key — NOT NULL
- BATHING_VEHICLE — BOOLEAN
- RANK — TINYINT
- START_DATE — DATE
- ID — BIGINT
- ADDRESS — CHARACTER
- ADDRESS_DETAIL — CHARACTER
- BRN — CHARACTER
- NAME — CHARACTER
- PHONE_NUMBER — CHARACTER
- SITE_URL — CHARACTER
HTE_COMMON_USER
- RN_ — INTEGER — Primary key — NOT NULL
- ID — BIGINT
- DTYPE — CHARACTER — NOT NULL
- DESCRIPTION — CHARACTER
- NAME — CHARACTER
- PASSWORD — CHARACTER
- PHONE_NUMBER — CHARACTER
- PHOTO — CHARACTER
- ROLE — CHARACTER
- USERNAME — CHARACTER
HTE_MATCHING
- RN_ — INTEGER — Primary key — NOT NULL
- CAREGIVER_CONDITION_ID — BIGINT
- CREATED_DATE — TIMESTAMP(6)
- ID — BIGINT
- WORKING_CONDITION_ID — BIGINT
- STATUS — ENUM('ACCEPT', 'PROGRESS', 'REFUSE')
HTE_SENIOR
- RN_ — INTEGER — Primary key — NOT NULL
- BIRTH — DATE
- CARE_RANK — INTEGER
- WEIGHT — INTEGER
- CENTER_ID — BIGINT
- ID — BIGINT
- ADDRESS — CHARACTER
- ADDRESS_DETAIL — CHARACTER
- GENDER — CHARACTER
- MEMO — CHARACTER
- PHOTO — CHARACTER
- SCHEDULE — CHARACTER
HTE_SOCIAL_WORKER
- RN_ — INTEGER — Primary key — NOT NULL
- ID — BIGINT
- DTYPE — CHARACTER — NOT NULL
- DESCRIPTION — CHARACTER
- NAME — CHARACTER
- PASSWORD — CHARACTER
- PHONE_NUMBER — CHARACTER
- PHOTO — CHARACTER
- ROLE — CHARACTER
- USERNAME — CHARACTER
HTE_USER
- RN_ — INTEGER — Primary key — NOT NULL
- ID — BIGINT
- DTYPE — CHARACTER — NOT NULL
- DESCRIPTION — CHARACTER
- NAME — CHARACTER
- PASSWORD — CHARACTER
- PHONE_NUMBER — CHARACTER
- PHOTO — CHARACTER
- ROLE — CHARACTER
- USERNAME — CHARACTER
HTE_WORKING_CONDITION
- RN_ — INTEGER — Primary key — NOT NULL
- WAGE — INTEGER
- ID — BIGINT
- SENIOR_ID — BIGINT
HTE_WORKING_CONDITION_TIME
- RN_ — INTEGER — Primary key — NOT NULL
- END_TIME — TIME(6)
- START_TIME — TIME(6)
- ID — BIGINT
- WORKING_CONDITION_ID — BIGINT
- WEEKDAY — CHARACTER
HT_COMMON_USER
- ID — BIGINT — Primary key — NOT NULL
HT_SOCIAL_WORKER
- ID — BIGINT — Primary key — NOT NULL
HT_USER
- ID — BIGINT — Primary key — NOT NULL