Event Photo Comment
Defines the structure of the event photo comment table
Table
Name: event_photo_comments
Columns
id (Primary Key)
Description: The unique identifier for the event photo comments table
Data Type: Unsigned bigint
Nullable: No
event_photo_comment_reply_id (Foreign Key)
Description: The event photo comment unique identifier
Data Type: Unsigned bigint
Nullable: No
Table: Event Photo Comments
event_photo_id (Foreign Key)
Description: The event photo unique identifier
Data Type: Unsigned bigint
Nullable: No
Table: Event Photo
user_id (Foreign Key)
Description: The user unique identifier
Data Type: Unsigned bigint
Nullable: No
Table: User
event_photo_comment
Description: The comment associated with the photo
Data Type: Text
Nullable: No
event_photo_comment_replies_count
Description: The total number of replies on the comment
Data Type: Unsigned integer - Default: 0
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