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