adventure_details¶
Info
This page was last generated 2023.04.23
Relationship Diagram(s)¶
Relationships¶
| Relationship Type | Local Key | Relates to Table | Foreign Key |
|---|---|---|---|
| Has-Many | id | adventure_members | id |
| One-to-One | id | adventure_template | id |
| Has-Many | id | adventure_template_entry | id |
| Has-Many | id | adventure_template_entry_flavor | id |
| One-to-One | adventure_id | adventure_template | id |
| One-to-One | instance_id | instance_list | id |
Schema¶
| Column | Data Type | Description |
|---|---|---|
| id | int | Unique Entry Identifier |
| adventure_id | smallint | Unique Adventure Identifier |
| instance_id | int | Instance Identifier |
| count | smallint | Count |
| assassinate_count | smallint | Assassinate Count |
| status | tinyint | Status |
| time_created | int | Time Created UNIX Timestamp |
| time_zoned | int | Time Zoned UNIX Timestamp |
| time_completed | int | Time Completed UNIX Timestamp |