Event Guest
Defines the structure of the event guests table
Table
Name: event_guests
Columns
id (Primary Key)
Description: The event guest unique identifier
Data Type: Unsigned bigint
Nullable: No
event_id (Foreign Key)
Description: The event unique identifier
Data Type: Unsigned bigint
Nullable: No
Table: Event
user_id (Foreign Key)
Description: The user unique identifier
Data Type: Unsigned bigint
Nullable: No
Table: User
event_guest_invite_type
Description: The invitation type for the guest
Data Type: Unsigned tinyint
Nullable: No
Values:
- Default - 1
- QR Code - 2
event_guest_status
Description: The status of the guest
Data Type: Unsigned tinyint
Nullable: No
Values:
- Attended - 1
- Invited - 2
- Interested - 3
- Accepted - 4
- Going - 7
- Admin - 8
event_guest_is_event_creator
Description: Indicates whether the guest is the creator of the event
Data Type: Unsigned tinyint
Nullable: No
created_at
Description: The timestamp when the record is created
Data Type: Timestamp
Nullable: Yes
updated_at
Description: The timestamp when the record is updated
Data Type: Timestamp
Nullable: Yes