수강신청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