first_end

테이블 (11)

Untitled (dept)

  • Key (dept_no) — varchar(8) — 기본 키 — NOT NULL
  • Field (dept_name) — varchar(30)
  • Field (loc) — varchar(30)

Untitled (memberme)

  • Key (id) — int(10) — 기본 키 — NOT NULL
  • Field (name) — varchar(20)
  • Field (phone1) — varchar(13)
  • Field (phone2) — varchar(13)

Untitled (profile)

  • Key (id) — int(10) — 기본 키 — NOT NULL
  • Field (name) — varchar(20)

Untitled (phonebook)

  • Field (phone) — varchar(30)
  • Key (id) — int(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (student_lecture)

  • Key (number) — int(10) — 기본 키 — NOT NULL
  • Key (lecture) — varchar(20) — 기본 키 — NOT NULL
  • Field (campus) — varchar(20)
  • Field (grade) — varchar(20)

Untitled (student_number)

  • Key (number) — int(10) — 기본 키 — NOT NULL
  • Field (campus) — varchar(20)

Untitled (lecture)

  • Field (lecture) — varchar(20)
  • Field (grade) — varchar(20)
  • Key (number) — int(10) — 외래 키 → Untitled.Key — NOT NULL

Untitled (winner)

  • Key (year) — int(6) — 기본 키 — NOT NULL
  • Field (winner) — varchar(20)

Untitled (teams)

  • Field (country) — varchar(20)
  • Field (coach) — varchar(20)
  • Key (year) — int(6) — 외래 키 → Untitled.Key — NOT NULL

worldcup

  • Key (Year) — int(6) — 기본 키 — NOT NULL
  • Field (winner) — varchar(20)
  • Field (coach) — varchar(20)

회원 (member)

  • Key (emp_no) — int(10) — 기본 키 — NOT NULL
  • Field (salary) — int(10)
  • Field (ename) — varchar(25)
  • Key (dept_no) — varchar(8) — 외래 키 → Untitled.Key — NOT NULL