GD_groupWare_team5

Tables (14)

Approval

  • App_doc_no — INT — Primary key — NOT NULL
  • App_attached_route — VARCHAR2(4000)
  • App_attached_name — VARCHAR2(1000)
  • App_content — VARCHAR2(4000)
  • App_title — VARCHAR2(1000) — NOT NULL
  • App_time — DATE
  • APP_ATTACHED_SIZE — NUMBER
  • Emp_ID — VARCHAR2(100) — Foreign key → Employee.Emp_ID — NOT NULL
  • App_statement — VARCHAR2(100)

Board_customer

  • Board_no — INT — Primary key — NOT NULL
  • Board_title — VARCHAR2(200)
  • Board_content — VARCHAR2(4000)
  • Board_fixed — VARCHAR2(100)
  • Board_time — DATE
  • Customer_id — VARCHAR2(500) — Foreign key → Customer.Customer_id — NOT NULL

Board_emp

  • Board_no — INT — Primary key — NOT NULL
  • Board_title — VARCHAR2(200) — NOT NULL
  • Board_content — VARCHAR2(4000)
  • Board_fixed — VARCHAR(100)
  • Board_time — DATE
  • Board_file_route — VARCHAR2(4000)
  • Emp_ID — VARCHAR2(100) — Foreign key → Employee.Emp_ID — NOT NULL
  • Board_file_size — NUMBER
  • BOARD_FILE_NAME — VARCHAR2(1000)

Book

  • Book_id — VARCHAR2(1000) — Primary key — NOT NULL
  • Book_name — VARCHAR2(1000)
  • Book_writer — VARCHAR2(100)
  • Book_ISBN — VARCHAR2(100)
  • Book_statement — VARCHAR2(100)
  • Book_location — VARCHAR2(500)
  • Book_DateOfReceipt — DATE
  • Book_publisher — VARCHAR2(100)
  • Book_pubyear — DATE
  • Book_edition — VARCHAR2(40)

Comment_customer

  • Comment_no — INT — Primary key — NOT NULL
  • Comment_writer — VARCHAR2(30)
  • Comment_content — VARCHAR2(2500)
  • Comment_time — DATE
  • Board_no — INT — Foreign key → Board_customer.Board_no — NOT NULL
  • Customer_id — VARCHAR2(500) — Foreign key → Customer.Customer_id — NOT NULL

Comment_emp

  • Comment_no — INT — Primary key — NOT NULL
  • Comment_content — VARCHAR2(2500)
  • Comment_time — DATE
  • Emp_ID — VARCHAR2(100) — Foreign key → Employee.Emp_ID — NOT NULL
  • Board_no — INT — Foreign key → Board_emp.Board_no — NOT NULL

Customer

  • Customer_id — VARCHAR2(100) — Primary key — NOT NULL
  • Customer_name — VARCHAR2(30)
  • Customer_address — VARCHAR2(500)
  • Customer_phone — VARCHAR2(100)
  • Customer_pw — VARCHAR2(1000)

Department

  • Dep_ID — VARCHAR2(100) — Primary key — NOT NULL
  • Dep_name — VARCHAR2(100)
  • Dep_address — VARCHAR2(1000)
  • Dep_manager_ID — VARCHAR2(500)

Employee

  • Emp_ID — VARCHAR2(100) — Primary key — NOT NULL
  • Emp_name — VARCHAR2(30) — NOT NULL
  • Emp_pw — VARCHAR2(500)
  • Emp_rank — VARCHAR2(50)
  • Emp_address — VARCHAR2(1000)
  • Emp_phone — VARCHAR2(50)
  • Emp_email — VARCHAR2(1000)
  • Emp_attached_pic_route — VARCHAR2(1000)
  • Emp_authority — INT
  • Emp_leave — VARCHAR2(100)
  • Emp_leave_date — DATE
  • Emp_in_date — DATE
  • Dep_ID — VARCHAR2(100) — Foreign key → Department.Dep_ID — NOT NULL

Mail

  • Mail_no — INT — Primary key — NOT NULL
  • Mail_title — VARCHAR2(100)
  • Mail_writer_id — VARCHAR2(100)
  • Mail_receiver_id — VARCHAR2(500)
  • Mail_content — VARCHAR2(4000)
  • Mail_attached_route — VARCHAR2(4000)
  • Mail_attached_name — VARCHAR2(1000)
  • MAIl_ATTACHED_SIZE (MAIL_ATTACHED_SIZE) — NUMBER
  • Mail_time — DATE
  • Mail_ref — VARCHAR(100)

Notice_event

  • Notice_no — INT — Primary key — NOT NULL
  • Notice_start — DATE
  • Notice_end — DATE
  • Notice_title — VARCHAR2(500)
  • Notice_content — VARCHAR2(4000)
  • Emp_ID — VARCHAR2(100) — Foreign key → Employee.Emp_ID — NOT NULL

Rental

  • Book_id — VARCHAR2(1000) — Foreign key → Book.Book_id — NOT NULL
  • Customer_id — VARCHAR2(100) — Foreign key → Customer.Customer_id — NOT NULL
  • Rental_start_date — DATE
  • Rental_end_date — DATE
  • Rental_returned — VARCHAR2(100

Reservation

  • Room_no — INT — Foreign key → Room.Room_no — NOT NULL
  • Customer_id — VARCHAR2(100) — Foreign key → Customer.Customer_id — NOT NULL
  • Reservation_starttime — DATE
  • Reservation_endTime — DATE
  • Reservation_authorization — VARCHAR2(100)

Room

  • Room_no — INT — Primary key — NOT NULL
  • Room_type — VARCHAR2(50)
  • Room_img — VARCHAR2(200)