dartbrief.ad_reward_transactions
Columns
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| created_at | timestamp with time zone | now() | false | |||
| transaction_id | text | false | ||||
| user_id | bigint | false | dartbrief.users |
Constraints
| Name | Type | Definition |
|---|---|---|
| ad_reward_transactions_pkey | PRIMARY KEY | PRIMARY KEY (transaction_id) |
| fk_ad_reward_transactions_user | FOREIGN KEY | FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE |
Indexes
| Name | Definition |
|---|---|
| ad_reward_transactions_pkey | CREATE UNIQUE INDEX ad_reward_transactions_pkey ON dartbrief.ad_reward_transactions USING btree (transaction_id) |
| idx_ad_reward_transactions_user_id | CREATE INDEX idx_ad_reward_transactions_user_id ON dartbrief.ad_reward_transactions USING btree (user_id) |
Relations
mermaid
erDiagram
"dartbrief.ad_reward_transactions" }o--|| "dartbrief.users" : ""
"dartbrief.ad_reward_transactions" {
bigint user_id FK
}
"dartbrief.users" {
bigint id
}Generated by tbls