데이터 베이스 시스템
테이블 (8)
tbl_Member
- Member_id — NUMBER — 기본 키 — NOT NULL
- Name — varchar2(15) — NOT NULL
- Address — varchar2(300) — NOT NULL
- Tell — varchar2(26) — NOT NULL
tbl_Payment_info
- Payment_id — NUMBER — 기본 키 — NOT NULL
- Member_id — NUMBER — 외래 키 → tbl_Member.Member_id
- payout — number
- payment_method — varchar2(6)
tbl_Server_Package
- Server_id — NUMBER — 기본 키 — NOT NULL
- Server_Volume — varchar2(10)
- SSD_OR_HHD — varchar2(6)
- CPU — VARCHAR2(150)
- RAM — VARCHAR2(150)
tbl_complete
- ip_address — varchar2(22) — 기본 키 — NOT NULL
- Member_id — NUMBER — 외래 키 → tbl_Member.Member_id
- Server_id — NUMBER — 외래 키 → tbl_Server_Package.Server_id
tbl_engineer_info
- engineer_id — NUMBER — 기본 키 — NOT NULL
- Area_in_charge — varchar2(100)
tbl_reservation
- reservation_id — NUMBER — 기본 키 — NOT NULL
- Server_id — NUMBER — 외래 키 → tbl_Server_Package.Server_id
- Member_id — NUMBER — 외래 키 → tbl_Member.Member_id
- engineer_id — NUMBER — 외래 키 → tbl_engineer_info.engineer_id
- Reservation_Date — DATE
tbl_salary_info
- engineer_id — NUMBER — 외래 키 → tbl_engineer_info.engineer_id — NOT NULL
- Basic_Salary — NUMBER
- extra_pay — NUMBER
- number_of_completions — NUMBER
서버 패키지 (Server Package)
- 서버 일련번호 (Server_id) — number — 기본 키 — NOT NULL
- 서버 용량 (Volume) — varchar2 (10) — NOT NULL
- SSD OR HHD (SSD_OR_HHD) — varchar2(6) — NOT NULL
- Field