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)