2월반 2
테이블 (6)
Untitled (STUDENT)
- Key (STU_ID) — VARCHAR2(20) — 기본 키 — NOT NULL
- Field (STU_PW) — VARCHAR2(20)
- Field2 (STU_NAME) — VARCHAR2(20)
- Field3 (STU_BIR) — DATE
- Field4 (STU_TEL) — VARCHAR2(20)
- Field (STU_ADD) — VARCHAR2(100)
- Field5 (STU_REGDATE) — DATE
- Field6 (STU_GPA) — NUMBER
- Key (TAKECLASS_ID) — VARCHAR2(20) — 외래 키 → Untitled3.Key — NOT NULL
Untitled (LECTURER)
- Key (LEC_ID) — VARCHAR2(20) — 기본 키 — NOT NULL
- Field (LEC_NAME) — VARCHAR2(20)
- Field2 (LEC_BIR) — DATE
- Field3 (LEC_TEL) — VARCHAR2(20)
- Field4 (LEC_SUBJECT) — VARCHAR2(20)
Untitled (QUESTION)
- Key (QA_NUM) — NUMBER — 기본 키 — NOT NULL
- Key (TAKECLASS_ID) — VARCHAR2(20) — 외래 키 → Untitled3.Key — NOT NULL
- Field (QA_TITLE) — VARCHAR2(200)
- Field (QA_CONTENT) — VARCHAR2(200)
- Field (STU_ID) — VARCHAR2(200)
- Field (QA_DATE) — DATE
Untitled2 (SUBJECT)
- Key (SUB_ID) — VARCHAR2(20) — 기본 키 — NOT NULL
- Field (SUB_GRADE) — NUMBER
- Field2 (SUB_NAME) — VARCHAR2(20)
- Key (LEC_ID) — VARCHAR2(20) — 외래 키 → Untitled.Key — NOT NULL
Untitled3 (TAKECLASS)
- Key (TAKECLASS_ID) — VARCHAR2(20) — 기본 키 — NOT NULL
- Field (TAKECLASS_ABSENCE) — VARCHAR2(20)
- Field2 (TAKECLASS_LIMIT) — VARCHAR2(20)
- Key (SUB_ID) — VARCHAR2(20) — 외래 키 → Untitled2.Key — NOT NULL
Untitled4 (NOTICE)
- Key (TAKECLASS_ID) — VARCHAR2(20) — 외래 키 → Untitled3.Key — NOT NULL
- Field (NOTICE_CONTENT) — VARCHAR2(20)