Appendix B. Hotel Entity Data Model and Design

We have used the Account entity to store hotel information. The Hotel entity will contain information about the rooms in the hotel, so we have created some new fields in the entity. The following tables show the data model for the Hotel entity:

Field name

Display name

Type

Custom attribute

Comments

Name

Hotel Name

String

False

Format: Text

Maximum length: 160

Room entity data model

The Room entity will store information about the room category and facilities available in that room. The following table shows the data model for the Room entity:

Field name

Display name

Type

Custom attribute

Comments

new_lcd

LCD

Boolean

True

True: Yes

False: No

Default value: Yes

new_freepickdrop

Free Pick & Drop

Boolean

True

True: Yes

False: No

Default value: Yes

new_phone

Phone

Integer

True

Minimum value: 0

Maximum value: 15

new_wifi

Wifi

Boolean

True

True: Yes

False: No

Default value: Yes

new_status

Status

Picklist

True

Options:

100000000: Booked

100000001: Available

Default: -1

new_morningtea

Morning Tea

Boolean

True

True: Yes

False: No

Default value: Yes

new_breakfastdinner

Breakfast & Dinner

Boolean

True

True: Yes

False: No

Default value: Yes

new_laundryservice

Laundry service

Boolean

True

True: Yes

False: No

Default value: Yes

new_bookingenddate

Booking End Date

DateTime

True

Format: Date only

new_bookingstartdate

Booking Start Date

DateTime

True

Format: Date only

new_roomtypeid

Room Type

Lookup

True

Targets: Product

new_parenthotelid

Parent Hotel

Lookup

True

Targets:

Account

new_newspaper

Newspaper

Boolean

True

True: Yes

False: No

Default value: Yes

new_room_no

Room_no

String

True

Format: Text

Maximum length: 100

new_maxguests

Max Guests

Picklist

True

Options:

100000000: 1

100000001: 2

100000002: 3

Default: -1

Ownerid

Owner

Owner

False

new_hairdryer

Hair dryer

Boolean

True

True: Yes

False: No

Default value: Yes

new_airconditioning

Air conditioning

Boolean

True

True: Yes

False: No

Default value: Yes

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.227.102.159