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