수강신청Project

테이블 (6)

Grade (Untitled3)

  • sn (Key2) — int — 외래 키 → subject.sn — NOT NULL
  • no (Key) — varchar(30) — 외래 키 → Student.no — NOT NULL
  • grade (Field) — varchar(30)

Student (Untitled)

  • no (Key) — varchar(30) — 기본 키 — NOT NULL
  • id (Field6) — varchar(30)
  • password (Field) — varchar(30)
  • name (Field2) — varchar(30)
  • rank (Field3) — int
  • total_score (Field4) — int
  • available_score (Field5) — int

grade

  • Key (user_no) — int — 외래 키 → users.Key — NOT NULL
  • Key (sn) — int — 외래 키 → subject.Key — NOT NULL
  • Field (grade) — string

subject

  • Key (sn) — int — 기본 키 — NOT NULL
  • Key (user_no) — int — 외래 키 → users.Key — NOT NULL
  • Field (name) — varchar(30)
  • Field2 (required_score) — int
  • Field3 (max_students) — int
  • Field4 (current_students) — int

subject (Untitled2)

  • sn (Key) — int — 기본 키 — NOT NULL
  • title (Field) — varchar(30)
  • professor (Field2) — varchar(30)
  • required_score (Field3) — int
  • max_students (Field4) — int
  • current_students (Field5) — int

users (user)

  • Key (user_no) — int — 기본 키 — NOT NULL
  • Field (name) — varchar(30)
  • Field2 (id) — varchar(30)
  • Field (password) — varchar(30)
  • Field (is_admin) — boolean
  • Field (rank) — int
  • Field (total_score) — int
  • Field (available_score) — int