20200309
Tables (9)
USER (학생)
- Key (아이디) — VARCHAR(20) — Primary key — NOT NULL
- Key (팀코드) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (프로젝트코드) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (반) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (지역코드) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (이름) — VARCHAR(100)
- Field2 (전화번호) — VARCHAR(20)
- Field3 (나이) — INT
- Field4 (성별) — VARCHAR(20)
- Field2 (기수) — INT
- Field (알고리즘등급) — VARCHAR(20)
- Field (알고리즘취득날짜) — DATETIME
- Field3 (등록자) — VARCHAR(20)
- Field4 (등록일자) — DATETIME
- Field6 (최종수정자) — VARCHAR(20)
- Field7 (최종수정일) — DATETIME
Untitled (출석)
- Key (날짜) — DATE — Primary key — NOT NULL
- Key (아이디) — VARCHAR(20) — Foreign key → USER.Key — NOT NULL
- Field (입실시간) — DATETIME
- Field2 (퇴실시간) — DATETIME
Untitled (시험)
- Key (시험코드) — INT — Primary key — NOT NULL
- Field (시험이름) — VAR_CHAR(20)
Untitled (성적)
- Key (아이디) — VARCHAR(20) — Foreign key → USER.Key — NOT NULL
- Key (시험코드) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (시험성적) — INT
Untitled (지역)
- Key (지역코드) — INT — Primary key — NOT NULL
- Field (지역이름) — VARCHAR(20)
Untitled (반)
- Key (반) — INT — Primary key — NOT NULL
- Key (지역코드) — INT — Foreign key → Untitled.Key — NOT NULL
- Key (강사아이디) — VARCHAR(20) — Foreign key → Untitled.Key — NOT NULL
Untitled (강사)
- Key (강사아이디) — VARCHAR(20) — Primary key — NOT NULL
- Field (강사이름) — VARCHAR(20)
- Field (강사전화번호) — VARCHAR(20)
Untitled (프로젝트)
- Key (프로젝트코드) — INT — Primary key — NOT NULL
- Field (프로젝트이름) — VARCHAR(50)
Untitled (팀)
- Key (팀코드) — INT — Primary key — NOT NULL
- Key (프로젝트코드) — INT — Foreign key → Untitled.Key — NOT NULL
- Field (팀성적) — INT