𧬠Together System
This is the together system database diagram.
classDiagram
direction TB
%%======== Tables ===============
class fu_together_images {
id: INT [PK AI NN IX]
name: VARCHAR-128 [NN UQ IX]
filename: VARCHAR-128 [[NN UQ IX]]
slug_combination: VARCHAR-128 [NN UQ IX]
sequence_number: INT [NN IX]
date_added: DATETIME [NN DV]
fu_regions_id: INT [FK NN IX]
fu_together_type_id: [FK NN IX]
}
class fu_together_type {
id: INT [PK AI NN IX]
type: VARCHAR-128 [NN UQ IX]
}
class fu_nations {
id: INT [PK AI NN IX]
nation: VARCHAR-128 [NN UQ IX]
nationality: VARCHAR-128 [NN UQ IX]
code: VARCHAR-6 [NN UQ IX]
}
class fu_regions {
id: INT [PK AI NN IX]
region: VARCHAR-128 [NN UQ IX]
slug: VARCHAR-128 [NN UQ IX]
fu_nations_id: INT [FK NN IX]
}
%%===============================
%%======== Relationships ========
fu_regions "0..*" --> "1" fu_nations : belongs to
fu_together_images "0..*" --> "1" fu_regions : belongs to
fu_together_images "0..*" --> "1" fu_together_type : belongs to
%%===============================
Legend
Keys
- PK - Primary Key
- FK - Foreign Key
Constraints
- AI - Auto Increment
- NN - Not Null
- UQ - Unique
- CK - Check Constraint
- DV - Default Value
Performance
- IX - Indexed Column
- FT - Full-Text Index