HOOPS
Tables (4)
COURTS
- COURT_ID — NUMBER
- COURT_NAME — VARCHAR2(100) — NOT NULL
- ADDRESS — VARCHAR2(255)
- IS_INDOOR — CHAR(1)
SCHEDULES
- SCHEDULE_ID — NUMBER
- USER_ID — NUMBER — Foreign key → USERS.USER_ID — NOT NULL
- COURT_ID — NUMBER — Foreign key → COURTS.COURT_ID — NOT NULL
- SCH_DATE — DATE — NOT NULL
- STATUS — VARCHAR2(20)
TRAINING_RECORDS
- RECORD_ID — NUMBER
- SCHEDULE_ID — NUMBER — Foreign key → SCHEDULES.SCHEDULE_ID — NOT NULL
- DRILL_TYPE — VARCHAR2(50) — NOT NULL
- ATTEMPTS — NUMBER
- SUCCESSES — NUMBER
USERS
- USER_ID — NUMBER
- EMAIL — VARCHAR2(100) — NOT NULL
- PASSWORD — VARCHAR2(255) — NOT NULL
- NICKNAME — VARCHAR2(50) — NOT NULL
- CREATED_AT — DATE