A803
Tables (5)
OPINION
- REPORT_ID — BIGINT — Primary key — NOT NULL
- DTYPE — VARCHAR(31) — NOT NULL
- DATE_TIME — DATETIME(6)
- MEMO — VARCHAR(255)
- START — DOUBLE
- TRAINER_ID — BIGINT — NOT NULL
- USER_ID — BIGINT — Foreign key → USER.USER_ID — NOT NULL
- TRAINER_ID (TRAINER_ID2) — BIGINT — Foreign key → TRAINER.TRAINER_ID — NOT NULL
PTLOG
- PTLOG_ID — BIGINT — Primary key — NOT NULL
- AEROBIC — INT
- BACK — INT
- BICEPS — INT
- CHEST — INT
- CORE — INT
- LEGS — INT
- MEMO — VARCHAR(255)
- SHOULDER — INT
- TRICEPS — INT
- USER_ID — BIGINT — Foreign key → USER.USER_ID — NOT NULL
RESERVATION
- RESERVATION_ID — BIGINT — Primary key — NOT NULL
- DATE_TIME — DATETIME(6)
- Field
- USER_ID — BIGINT — Foreign key → USER.USER_ID — NOT NULL
- TRAINER_ID — BIGINT — Foreign key → TRAINER.TRAINER_ID — NOT NULL
TRAINER
- TRAINER_ID — BIGINT — Primary key — NOT NULL
- ADDRESS — VARCHAR(255)
- AGE — INT
- APPROVED — BIGINT
- EMAIL — VARCHAR(255)
- GENDER — VARCHAR(255)
- LICENSE — VARCHAR(255)
- PASSWORD — VARCHAR(255)
- PHONE — VARCHAR(255)
- ROLE — VARCHAR(255)
USER
- USER_ID — BIGINT — Primary key — NOT NULL
- ADDRESS — VARCHAR(255)
- AGE — INT — NOT NULL
- EMAIL — VARCHAR(255)
- GENDER — VARCHAR(255)
- PASSWORD — VARCHAR(255)
- PHONE — VARCHAR(255)
- ROLE — VARCHAR(255)
- TICKET — INT — NOT NULL