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)