Coach ERD

Tables (7)

COACH_CUSTOMER (Untitled3)

  • CustomerCode (Key2) — Char(16) — Foreign key → CustomerINFO.Code — NOT NULL — 난수생성
  • CoachCode (Key) — Char(16) — Foreign key → CoachINFO.Code — NOT NULL — 난수 생성

CoachINFO (Untitled)

  • Code (Key) — Char(16) — Primary key — NOT NULL — 난수 생성
  • Name (Field) — Char(10) — NOT NULL
  • Phone (Field2) — INT(11) — NOT NULL
  • Company (Field3) — Char(10)
  • Email (Field4) — Char(25) — NOT NULL

CoachingLog (Untitled6)

  • LogID (Key3) — INT — Primary key — NOT NULL
  • CustomerCode (Key2) — Char(16) — Foreign key → CustomerINFO.Code — NOT NULL — 난수생성
  • CoachCode (Key) — Char(16) — Foreign key → CoachINFO.Code — NOT NULL — 난수 생성
  • Date (Field) — Date — NOT NULL
  • StartTime (Field2) — Time — NOT NULL
  • EndTime (Field3) — Time — NOT NULL
  • Content (Field4) — Char(2000)
  • Type (Field5) — Char(10) — NOT NULL

CustomerINFO (Untitled2)

  • Code (Key) — Char(16) — Primary key — NOT NULL — 난수생성
  • Name (Field) — Char(10) — NOT NULL
  • Phone (Field2) — INT(11) — NOT NULL
  • Email (Field3) — Char(25) — NOT NULL

Question (Untitled5)

  • QuestionCode (Key2) — INT — Primary key — NOT NULL
  • CoachCode (Key) — Char(16) — Foreign key → CoachINFO.Code — 난수 생성
  • Question (Field) — Char(200) — NOT NULL

QuetionLog (Untitled7)

  • QuestionCode (Key2) — INT — Foreign key → Question.QuestionCode — NOT NULL
  • CustomerCode (Key) — Char(16) — Foreign key → CustomerINFO.Code — NOT NULL — 난수생성
  • Date (Field) — Date — NOT NULL
  • Content (Field2) — Char(2000) — NOT NULL

Schedule (Untitled4)

  • ID (Key) — INT — Primary key — NOT NULL
  • CustomerCode (Key3) — Char(16) — Foreign key → CustomerINFO.Code — NOT NULL — 난수생성
  • CoachCode (Key2) — Char(16) — Foreign key → CoachINFO.Code — NOT NULL — 난수 생성
  • Date (Field) — Date — NOT NULL
  • Comment (Field2) — Char(200)
  • Name (Field3) — Char(30) — NOT NULL