modify

Tables (8)

Address (address)

  • Zipcode (zipcode) — VARCHAR(50)
  • Street (street) — VARCHAR(50)
  • City (city) — VARCHAR(50)

Auth (auth)

  • EmployeeAuthNo (employeeAuthNo) — BIG_INT — Primary key — NOT NULL
  • Employee_no (employee_no) — BIG_INT — Foreign key → Employee.Employee_no — NOT NULL
  • Auth (auth) — VARCHAR(30)
  • RegDate (regDate) — Date
  • UpDate (upDate) — Date

Board (board)

  • Board_no (board_no) — BIG_INT — Primary key — NOT NULL
  • EmployeeAuthNo (employeeAuthNo) — BIG_INT — Foreign key → Auth.EmployeeAuthNo — NOT NULL
  • Title (title) — VARCHAR(100)
  • Writer (writer) — VARCHAR(50)
  • Content (content) — VARCHAR(1000)
  • RegDate (regDate) — Date
  • UpDate (upDate) — Date

Calendar (calendar)

  • Calendar_no (calendar_no) — BIG_INT — Primary key — NOT NULL
  • Employee_no (employee_no) — BIG_INT — Foreign key → Employee.Employee_no — NOT NULL
  • Name (name) — VARCHAR(10)
  • Details (details) — VARCHAR(10)
  • Email (email) — VARCHAR(100)
  • Start (start) — Date
  • End (end) — Date

Employee (employee)

  • Employee_no (employee_no) — BIG_INT — Primary key — NOT NULL
  • Team_no (team_no) — BIG_INT — Foreign key → Team.Team_no — NOT NULL
  • Email (email) — VARCHAR(100)
  • Name (name) — VARCHAR(50)
  • Password (password) — VARCHAR(200)
  • PhoneNumber (phoneNumber) — VARCHAR(20)
  • Team (team) — VARCHAR(20)
  • RegDate (regDate) — Date
  • UpDate (upDate) — Date

Project (project)

  • Project_no (project_no) — BIG_INT — Primary key — NOT NULL
  • Team_no (team_no) — BIG_INT — Foreign key → Team.Team_no — NOT NULL
  • Title (title) — VARCHAR(20)
  • Team (team) — VARCHAR(10)
  • Person (person) — VARCHAR(20)
  • Due (due) — Date
  • Status (status) — VARCHAR(10)

Schedule (schedule)

  • Schedule_no (schedule_no) — BIG_INT — Primary key — NOT NULL
  • Employee_no (employee_no) — BIG_INT — Foreign key → Employee.Employee_no — NOT NULL
  • Name (name) — VARCHAR(20)
  • Email (emailE) — VARCHAR(50)
  • Team (team) — VARCHAR(50)
  • Time8 (time8) — VARCHAR(20)
  • Time9 (time9) — VARCHAR(20)
  • Time10 (time10) — VARCHAR(20)
  • Time11 (time11) — VARCHAR(20)
  • Time12 (time12) — VARCHAR(20)
  • Time13 (time13) — VARCHAR(20)
  • Time14 (time14) — VARCHAR(20)
  • Time15 (time15) — VARCHAR(20)
  • Time16 (time16) — VARCHAR(20)
  • Time17 (time17) — VARCHAR(20)
  • Time18 (time18) — VARCHAR(20)
  • Time19 (time19) — VARCHAR(20)
  • Time20 (time20) — VARCHAR(20)

Team (team)

  • Team_no (team_no) — BIG_INT — Primary key — NOT NULL
  • Team (team) — VARCHAR(20)