account_rewards¶
Relationships¶
erDiagram
account_rewards {
intunsigned account_id
intunsigned reward_id
}
veteran_reward_templates {
intunsigned claim_id
intunsigned item_id
}
account_rewards ||--o{ veteran_reward_templates : "One-to-One"
| Relationship Type | Local Key | Relates to Table | Foreign Key |
|---|---|---|---|
| One-to-One | reward_id | veteran_reward_templates | claim_id |
Schema¶
| Column | Data Type | Description |
|---|---|---|
| account_id | int | Account Identifier |
| reward_id | int | Veteran Reward Identifier |
| amount | int | Amount |