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)