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