Character relationshipsTable: Difference between revisions
Jump to navigation
Jump to search
Created page with '{| border="1" |- ! field ! type ! foreign key ! description |- | character_id | integer | | |- | related_id | integer | | |- | relationship_type | varchar | | |- | spousena…' |
No edit summary |
||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
{| | |||
{| class="wikitable" | |||
|+ | |||
!UE | |||
!Field | |||
!Type | |||
!Key Type | |||
!Default | |||
!Extra | |||
!Description | |||
|- | |- | ||
| | |||
|character_id | |||
|int(10) unsigned | |||
|PRI | |||
|0 | |||
| | |||
|character id from the characters table | |||
|- | |- | ||
| | | | ||
| | |related_id | ||
| | |int(10) unsigned | ||
| | |PRI | ||
|0 | |||
| | |||
|character id of the related character | |||
|- | |- | ||
| | | | ||
| | |relationship_type | ||
| | |varchar(15) | ||
| | |PRI | ||
| | |||
| | |||
|one of three values currently `familiar`, `buddy`, `spouse` or `exploration` | |||
|- | |- | ||
| | | | ||
| | |spousename | ||
| | |varchar(30) | ||
| | | | ||
| | | | ||
| | |||
|used for marriages, historical data in case of deletion | |||
| | |||
| | |||
|} | |} | ||
[[Category:Engine documents]] | |||
Latest revision as of 11:53, 11 January 2022
| UE | Field | Type | Key Type | Default | Extra | Description |
|---|---|---|---|---|---|---|
| character_id | int(10) unsigned | PRI | 0 | character id from the characters table | ||
| related_id | int(10) unsigned | PRI | 0 | character id of the related character | ||
| relationship_type | varchar(15) | PRI | one of three values currently `familiar`, `buddy`, `spouse` or `exploration` | |||
| spousename | varchar(30) | used for marriages, historical data in case of deletion |