2019056462

Tables (11)

Account (거래 (ex, 식품, 생활용품, 어메너티등))

  • accountName (Key) — VARCHAR(20) — Primary key — NOT NULL
  • accountNum (Key2) — VARCHAR(10) — Primary key — NOT NULL
  • accountType (Field) — VARCHAR(20)
  • deptName (Field2) — VARCHAR(15)
  • empID (Field3) — VARCHAR(20)
  • accountDate (Field4) — DATETIME

Claim (요구사항)

  • claimNum (Key) — VARCHAR(20) (ex 2019-1) — Primary key — NOT NULL
  • guestID (Field) — VARCHAR(20)
  • empID (Field2) — VARCHAR(20)
  • claimType (Field3) — VARCHAR
  • meaasge (Field4) — VARCHAR(500)
  • solved (Field5) — CHAR(1)

Department (부서)

  • deptName (Key) — VARCHAR(15) — Primary key — NOT NULL
  • deptBudget (Field) — DOUBLE
  • deptPhone1 (Field2) — VARCHAR(15)
  • deptPhone2 (Field3) — VARCHAR(15)

Employee (직원)

  • empID (Key) — VARCHAR(20) — Primary key — NOT NULL
  • lastName (Field1) — VARCHAR(20)
  • salary (Field2) — DOUBLE
  • gender (Field3) — CHAR(1)
  • phoneNum (Field4) — CHAR(11)
  • deptName (Field5) — VARCHAR(15)
  • empAdress1 (Field6) — VARCHAR(20)
  • empAdress2 (Field7) — VARCHAR(20)
  • empAdress3 (Field8) — VARCHAR(20)
  • empAdress4 (Field9) — VARCHAR(20)
  • position (Field10) — VARCHAR(20)
  • workPeriod (or joinDate) (Field11) — FLOAT (or DATE)
  • nowGuest (Field12) — INT
  • maxGuest (Field13) — INT
  • assignPossible (Field14) — CHAR(1)
  • empBirthday (Field15) — DATE

Expenditure (지출)

  • expenNum (Key2) — INT — Primary key — NOT NULL
  • financeYear (Field) — VARCHAR(15)
  • expenType (Field2) — VARCHAR(15)
  • expenAamount (Field3) — FLOAT
  • expenDate (Field4) — DATETIME

Facilities (편의시설)

  • facName (Key) — VARCHAR(15) — Primary key — NOT NULL
  • guestID (Field) — VARCHAR(20)
  • cost (Field2) — FLOAT
  • facPhone1 (Field4) — VARCHAR(15)

Guest (손님)

  • guestID (Key1) — VARCHAR(20) — Primary key — NOT NULL
  • firstName (Field) — VARCHAR(20)
  • lastName (Field2) — BARCHAR(20)
  • phoneNum (Field3) — CHAR(11)
  • gender (Field4) — CHAR(1)
  • guestAddress1 (Field5) — VARCHAR(20)
  • guestAddress2 (Field6) — VARCHAR(20)
  • guestAddress3 (Field7) — VARCHAR(20)
  • guestAddress4 (Field8) — VARCHAR(50)
  • geustGrade (Field9) — VARCHAR(10)
  • mileage (Field10) — DOUBLE
  • guestEmail (Field11) — VARCHAR(40)
  • guestBrithday (Field12) — DATE

Promotion (행사)

  • eventNum (Key) — VARCHAR(10) — Primary key — NOT NULL
  • eventName (Field) — VARCHAR(20)
  • deptName (Field2) — VARCHAR(15)
  • beginDate (Field3) — DATE
  • ednDate (Field4) — DATE
  • guestGrade (Field5) — VARCHAR(10)

Reserved (예약된 방)

  • roomNum (Key) — INT — Primary key — NOT NULL
  • guestID (Field) — VARCHAR
  • empID (Field2) — VARCHAR
  • checkIn (Field3) — DATETIME
  • checkOut (Field5) — DATETIME
  • reserveDate (Field4) — DATETIME

Revenue (수입)

  • revenNum (Key) — INT — Primary key — NOT NULL
  • financeYear (Field) — VARCHAR(6)
  • RevenType (Field2) — VARCHAR(15)
  • revenAmount (Field3) — FLOAT
  • revenDate (Field4) — DATETIME

Room (방)

  • RoomNum (Key) — VARCHAR(10) — Primary key — NOT NULL
  • roomType (Field) — VARCHAR(15)
  • isReserved (Field2) — CHAR(1)
  • floor (Field3) — VARCHAR(3)
  • isClean (Field4) — CHAR(1)
  • wdayPrice (Field5) — DOUBLE
  • wendPrice (Field6) — DOUBLE