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