데이터 베이스 시스템

테이블 (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