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