Change types to what we saw in internal tool on stream

[SnosMe]

No description provided.

[evanwarner]

Hash columns are unsigned integers, as can be seen in Jonathan's stream. Currently no way to define that in the schema.

[SnosMe]

While true, they are not used anywhere else. And too be more nerdy hashes are not numbers in common sense😄

[evanwarner]

Haha, yep that's fair. Just thought I'd mention it if you were planning to do an update to type definitions.

[Vilsol]

Just documenting from what we can see from stream:

• They have organized the schemas into logical directories (e.g. Voting -> VoteState, VoteType).
• They have the following data types: String, Decimal, Bool, File, Directory, Reference, Interval, Color, Point, Enum, DateTime
• Columns can be Calculated and Localized.
• Tables always start with an ID column.

The actual tables we see:

BaseItemTypes

• ID: String
• Display Name: String
• Gender: ?
• Level: Int
• Level_PoEM: Int?
• Width: Int
• Height: Int
• (D)efault Visual Identi(?): Reference
• Parent Object: String?
• Item Class: Reference
• Flavour Text: ?
• Use Sound: Reference
• Implicit Mods: ?
• Right Click Sound: ?
• World Item Object Size: Int
• Tag Set: String?
• ModDomain: ?
• Hide from site: bool
• TypeNameHash: Int
• (?)VendorAchievem(?): String?
• (?)EquipAchievem(?): ?
• (?)ifyMagicEchiev(?): ?
• Normal Cost Quantities: Int
• Magic Cost Items: ?
• Magic Cost Quantities: ?
• Rare Cost Items: ?
• ...?

ItemClasses

• Id: String
• ot_file: File?
• Display Name: String
• MarketCategory: String
• (?)emClassCategory(?): Reference
• Default Stance Type: Reference
• Instance Local: Bool
• Always Allocate: Bool
• Allocate To Map Maker: Bool
• Crafting Achievements: ?
• Identify Rare Achievements: ?
• Can Have Influence: Bool
• Can Be Corrupted: Bool
• Can Be Super Corrupted: Bool
• Can Have Incubators: Bool
• Can Have Aspects: Bool
• Can Add Veiled Mods: Bool
• Always Show: Bool
• Pickup Quest Flag: ?
• Can Be Skin Transferred: Bool
• Pickup League Flag: ?

ItemVisualEffect

• Id: String
• Bow: File
• Mace1hScep: File
• Sword1h: File
• Sword2h: File
• Staff: File
• DgrWnd: File
• Armour: ?
• Mace2h: File
• Axe1h: File
• Axe2h: File
• Claw: File
• Shield: File
• On Hit Effect: File
• Hash: Int

Mods

• Id: String
• Hash Id: Int
• ModType: Reference
• ModFamily: String
• ModDomain: Reference
• Name: String
• Generation Type: Reference
• Level: Int
• Maximum Level: Int
• Tags: Reference
• Affinities: Int Array
• Disabled On Console: Bool
• Multiplier Tags: ?
• Multiplier Values: ?
• Use HardMode Magniutes: Bool
• Stat Magnitude1 Stat: Reference
• Stat Magnitude1: Interval?
• Stat Magnitude1 Hardmode: Interval?
• ...?