Character relationshipsTable: Difference between revisions

Latest revision as of 11:53, 11 January 2022


Field	Type	Key Type	Default	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

@@ Line 1: / Line 1: @@
-{| border="1"
+{| class="wikitable"
+|+
+!UE
+!Field
+!Type
+!Key Type
+!Default
+!Extra
+!Description
 |-
-! field
+|
-! type
+|character_id
-! foreign key
+|int(10) unsigned
-! description
+|PRI
+|0
+|
+|character id from the characters table
 |-
-| character_id
+|
-| integer
+|related_id
-|
+|int(10) unsigned
-|
+|PRI
+|0
+|
+|character id of the related character
 |-
-| related_id
+|
-| integer
+|relationship_type
-|
+|varchar(15)
-|
+|PRI
+|
+|
+|one of three values currently `familiar`, `buddy`, `spouse` or `exploration`
 |-
-| relationship_type
+|
-| varchar
+|spousename
-|
+|varchar(30)
 |
-|-
+|
-| spousename
+|
-| varchar
+|used for marriages, historical data in case of deletion
-|
-|
 |}
 [[Category:Engine documents]]