Skip to Content
File StructurePackagesDbAuth

Table: Features

ColumnData TypeDescription
idserialUnique identifier for the feature. It’s the primary key.
nametextName of the feature.
slugtextSlug of the feature.
createdAttimestampDate and time when the feature was created. It’s automatically set when creating the feature.
updatedAttimestampDate and time when the feature was last updated.
isActivebooleanIndicates whether the feature is active. Defaults to true.
createdBytextUser who created the feature.
updatedBytextUser who last updated the feature.
displayNametextDisplay name of the feature.

Table: Scopes

ColumnData TypeDescription
idserialUnique identifier for the scope. It’s the primary key.
nametextName of the scope.
slugtextSlug of the scope.
featureIdintegerIdentifier of the feature that the scope belongs to. It’s a foreign key referencing Features.id.
createdAttimestampDate and time when the scope was created. It’s automatically set when creating the scope.
updatedAttimestampDate and time when the scope was last updated.
isActivebooleanIndicates whether the scope is active. Defaults to true.
createdBytextUser who created the scope.
updatedBytextUser who last updated the scope.
displayNametextDisplay name of the scope.

Table: Actions

ColumnData TypeDescription
idserialUnique identifier for the action. It’s the primary key.
nametextName of the action.
slugtextSlug of the action.
createdAttimestampDate and time when the action was created. It’s automatically set when creating the action.
updatedAttimestampDate and time when the action was last updated.
isActivebooleanIndicates whether the action is active. Defaults to true.
Last updated on