DATA

Tables (5)

Membership_Registration_Data

  • ID (Key) — TYPE — Primary key — NOT NULL
  • UserID — VARCHAR(50) — NOT NULL
  • UserPassword — VARCHAR(50) — NOT NULL
  • eMail — VARCHAR(50) — NOT NULL
  • eMail_Address — VARCHAR(50) — NOT NULL
  • chked1 — BOOLEAN — NOT NULL
  • chked2 — BOOLEAN — NOT NULL
  • chked3 — BOOLEAN — NOT NULL
  • chked4 — BOOLEAN — NOT NULL
  • chked5 — BOOLEAN — NOT NULL

Pick

  • ID — INT
  • User_ID — INT — Foreign key
  • Key — Foreign key → User.Key — NOT NULL

PlayMusic

  • ID — INT
  • User_ID — INT — Foreign key
  • Key — Foreign key → User.Key — NOT NULL

Playlist

  • ID — INT
  • User_ID — INT — Foreign key
  • Key — Foreign key → User.Key — NOT NULL

User

  • Membership_Registration_Data_ID — INT — Foreign key
  • Key — Foreign key → Membership_Registration_Data.ID — NOT NULL
  • ID (Key2) — TYPE — Foreign key → Membership_Registration_Data.ID — NOT NULL