Template:Board/Cargo: Difference between revisions

From Phantasy Star Universe Clementine
No edit summary
(overhaul to structure)
 
Line 2: Line 2:
{{#cargo_declare:
{{#cargo_declare:
_table = Boards
_table = Boards
|_parentTables = Items(_localField=make_id, _remoteField=id, _alias=ItemBoard);
|_parentTables = Items(_localField=id, _remoteField=id, _alias=ItemBoard);
<!--
BOARD PROPERTIES
-->
|id = String (mandatory;unique;regex=[A-F0-9]{8};size=8)
|id = String (mandatory;unique;regex=[A-F0-9]{8};size=8)
|name = String (size=32)
|name = String (size=32)  
|make_id = String (mandatory;regex=[A-F0-9]{8};size=8)
<!--
|time_to_synth = Float
description omitted. It will be added to the Items table instead.
|uses = Float
-->
|min_synth_rate = Integer
|rarity = Integer (allowed values=0,1,2,3,4,5,6,7,8,9,10,11,12,13,14)
|max_synth_rate = Integer
<!--
rank omitted as it is not displayed to the client, nor is it used in any calculations.
buy_price omitted as it is unused.
sell_price omitted as it is unused.
sort_order omitted as it is deemed unimportant to store in the database.
branch_type omitted as its importance is unknown and consequentially so is its importance.
account_bound omitted.
--><!--
SYNTHESIS PROPERTIES
-->
|success_rate = Integer <!-- is there a way to enforce a check condition in cargo? seems like storing 101 strings(?) to potentially compare to is very bad --><!--
max_nb_craft omitted as it its functionality is unknown.
-->
|craft_time = Integer
|bot_stat_striking = Integer
|bot_stat_ranged = Integer
|bot_stat_technic = Integer
|bot_stat_armor = Integer
<!--
bot_stat[4] omitted as the fifth value is both unknown and currently inconsequential.
select_quantity omitted as it is deemed unimportant to store in the database.
select_slot omitted as it is deemed unimportant to store in the database.
-->
}}</noinclude>
}}</noinclude>

Latest revision as of 22:44, 9 January 2025


This template defines the table "Boards". View table.