TripOn

Table

c2b_hote_master(updated)

• hotel_id (PK) INT AUTO_INCREMENT Unique hotel ID
• loc_id (FK)INT References c2b_loc_master.loc_id
• hotel_name VARCHAR(150) Name of the hotel
• description TEXt Hotel description
• image_url VARCHAR(255) Hotel image URL
• email VARCHAR(150) Hotel email address
• username VARCHAR(200) Auto-generated login username
• password VARCHAR(255) Auto-generated encrypted password
• is_active BOOLEAN DEFAULT TRUE Active / inactive status
• created_at DATETIME Record created date
• updated_at DATETIME Record updated

Validation

Email Validation

• Must be valid format
• Must be unique
• Same email cannot be used twice

Username Validation

• Must be auto-generated
• Must be unique
• Cannot be edited manually

Password Validation

• Must be auto-generated
• Must be stored encrypted
• Cannot store plain password