temp

Tables (5)

Untitled (학생)

  • key (아이디) — VARCHAR2(20) — Primary key
  • Field (비밀번호) — VARCHAR2(20)
  • Field (이름) — VARCHAR2(10)

Untitled (강의목록)

  • Key (강의_고유번호) — NUMBER — Primary key — NOT NULL
  • Field (강의 이름) — VARCHAR2(30)
  • Field (강의 교수) — VARCHAR2(30)
  • Field (강의시간대) — VARCHAR2(10)
  • Field (수강인원) — NUMBER

Untitled (장바구니)

  • Key (아이디) — VARCHAR2(20) — Foreign key → Untitled.key
  • Key (강의_고유번호) — NUMBER — Foreign key → Untitled.Key — NOT NULL

Untitled (출석)

  • Field2 (아이디) — VARCHAR2(20) — Foreign key → Untitled.key
  • Field (날짜) — TIMESTAMP
  • Field (출석_여부) — NUMBER

Untitled (수강내역)

  • Field2 (아이디) — VARCHAR2(20) — Foreign key → Untitled.key