졸업 프로젝트 ERD2

테이블 (7)

Company

  • Key (com_keyId) — number — 기본 키 — NOT NULL
  • Field (com_num)
  • Field (com_name) — varchar(100)
  • Field (com_representive) — varchar(100)
  • Field (com_cellphone) — number
  • Field (com_email) — varchar(100)
  • Field (com_identification) — varchar(50)
  • Field (com_password) — varchar(50)
  • Field (com_sector) — varchar
  • Field (com_product) — text
  • Field (com_annualSales) — number
  • Key (com_team) — number — 외래 키 → Team.Key — NOT NULL

Schedule

  • Key (sch_num) — number — 기본 키 — NOT NULL
  • Field (sch_content) — text
  • Field2 (sch_enddate) — date
  • sch (sch_complete) — boolean
  • Key (sch_manager) — number — 외래 키 → Student.Key — NOT NULL

Student

  • Key (std_keyId) — number — 기본 키 — NOT NULL
  • Field (std_studentId) — number
  • Field (std_name) — varchar(100)
  • Field (std_department) — varchar(50)
  • Field (std_email) — varchar(100)
  • Field (std_phonenum) — number
  • Field (std_identification) — varchar(50)
  • Field (std_password) — varchar(50)
  • Field (std_interest1) — varchar(50)
  • Field2 (std_interest2) — varchar(50)
  • Field3 (std_interest3) — varchar(50)
  • Field4 (std_interest4) — varchar(50)
  • Field5 (std_interest5) — varchar(50)
  • Field6 (std_interest6) — varchar(50)
  • Key (std_team) — number — 외래 키 → Team.Key — NOT NULL

Team

  • Key (team_keyId) — number — 기본 키 — NOT NULL
  • Field (team_subject) — text

companyBoard (ComBoard)

  • Key (cb_num) — number — 기본 키 — NOT NULL
  • Field (cb_field) — varchar
  • Field2 (cb_title) — varchar
  • Field3 (cb_content) — text
  • Key (cb_writer) — number — 외래 키 → Company.Key — NOT NULL

tb_attach

  • Key (a_id) — number — 기본 키 — NOT NULL
  • Field2 (a_uploadPath) — varchar(200)
  • Field3 (a_filename) — varchar(200)
  • Field4 (a_filetype) — char(1)
  • Key (a_board) — number — 외래 키 → teamBoard.Key — NOT NULL

teamBoard

  • Key (teamboard_keyid) — number — 기본 키 — NOT NULL
  • Field (tb_title) — varchar
  • Field (tb_content) — text
  • Field (tb_date) — date
  • Field (tb_writer) — varchar(100)
  • Key (tb_team) — number — 외래 키 → Team.Key — NOT NULL