PJT

Tables (3)

BLIND_LOCATE

  • TIMESTAMP — DATETIME — Primary key — NOT NULL
  • USER_ID — INT — Foreign key → USER.USER_ID — NOT NULL
  • LATITUDE — FLOAT
  • LONGITUDE — FLOAT

BLIND_MESSAGE

  • Key — Primary key — NOT NULL

USER

  • USER_ID — INT — Primary key — NOT NULL
  • ID — varchar(20) — NOT NULL
  • PASSWORD — varchar(20) — NOT NULL
  • BLIND — TINYINT(1)
  • FAMILY — TINYINT(1)
  • ADMIN — TINYINT(1)
  • PHONE_NUMBER — varchar(20)
  • USER_NAME — varchar(20)
  • USER_DESCRIPTION — varchar(100)