ssafy
Tables (5)
device (Untitled2)
- PK (device_id) — INT — Primary key — NOT NULL
- FK (student_id) — INT — Foreign key → student.PK — NOT NULL
- 제목 (title) — VARCHAR
- 구입년월일 (purchase_date) — DATE
- 대여일 (rental_date) — DATE
- 반납일 (return_date) — DATE
mgr_pro (Untitled)
- PK (mgr_id) — INT — Primary key — NOT NULL
- 이름 (name) — VARCHAR
- 전화번호 (phone) — VARCHAR
- 담당지역 (region) — VARCHAR
- 담당반 (class) — VARCHAR
- 팀 (team) — VARCHAR
project (Untitled4)
- PK (project_id) — INT — Primary key — NOT NULL
- 순번 (sequence) — VARCHAR
- 제목 (title) — VARCHAR
project_student (Untitled5)
- PK (project_student_id) — INT — Primary key — NOT NULL
- FK (student_id) — INT — Foreign key → student.FK — NOT NULL
- FK (project_id) — INT — Foreign key → project.PK — NOT NULL
student (Untitled3)
- PK (student_id) — INT — Primary key — NOT NULL
- FK (mgr_id) — INT — Foreign key → mgr_pro.PK — NOT NULL
- 이름 (name) — VARCHAR
- 전화번호 (phone) — VARCHAR
- 캠퍼스 지역 (region) — VARCHAR
- Field