데베시

테이블 (6)

Court (COURT)

  • Key (CourtID) — int — 기본 키 — NOT NULL
  • Field (Capacity) — varchar(50)
  • Field2 (CourtType) — varchar(50)
  • Key (MatchID) — 외래 키 → Match.Key — NOT NULL

Match (MATCH)

  • Key (MatchID) — 기본 키 — NOT NULL
  • Field (Time) — Time
  • Field2 (Date) — Date
  • Key (ParticipantID) — int — 외래 키 → Participant.Key — NOT NULL

Participant (PARTICIPANT)

  • Key (ParticipantID) — int — 기본 키 — NOT NULL
  • Field (Name) — varchar(50)
  • Field2 (Address) — varchar(50)

Tournament (TOURNAMENT)

  • Key (TournamentID) — INT — 기본 키 — NOT NULL
  • Field (NoTimesPrYear) — varchar(50)
  • Field2 (Location) — varchar(50)
  • Field3 (Name) — varchar(50)
  • Key (MatchID) — 외래 키 → Match.Key — NOT NULL
  • Key (ParticipantID) — int — 외래 키 → Participant.Key — NOT NULL

Untitled (PATIENT)

  • Key (patientID) — 기본 키 — NOT NULL
  • Field2 (NAME)
  • Field3 (address)

Untitled2 (DEPARTMENT)

  • Key (petname) — 기본 키 — NOT NULL
  • Field (birthDate)
  • Key (patientID) — 외래 키 → Untitled.Key — NOT NULL
  • Key (patientID2) — 외래 키 → Untitled.Key — NOT NULL
  • Key (patientID3) — 외래 키 → Untitled.Key — NOT NULL