| # | Column Name | Nullable | Data Type | Max Length | Description |
|---|---|---|---|---|---|
| 1 | non_gl_stock_master_relation_id | bigint | 0 | The primary key of this table, which is also a serial field. | |
| 2 | order_non_gl_stock_master_id | bigint | 0 | Foreign key to the table transactions.non_gl_stock_master. | |
| 3 | quotation_non_gl_stock_master_id | bigint | 0 | Foreign key to the table transactions.non_gl_stock_master. |
| # | Column Name | Key Name | References |
|---|---|---|---|
| 2 | order_non_gl_stock_master_id | non_gl_stock_master_relations_order_non_gl_stock_master_id_fkey | transactions.non_gl_stock_master.non_gl_stock_master_id |
| 3 | quotation_non_gl_stock_master_id | non_gl_stock_master_relations_quotation_non_gl_stock_maste_fkey | transactions.non_gl_stock_master.non_gl_stock_master_id |
| Index Name | Owner | Access Method | Definition | Description |
|---|---|---|---|---|
| non_gl_stock_master_relations_pkey | postgres | btree | non_gl_stock_master_relation_id |
| Constraint Name | Description |
|---|
| # | Column Name | Default |
|---|---|---|
| 1 | non_gl_stock_master_relation_id | nextval('transactions.non_gl_stock_master_relations_non_gl_stock_master_relation__seq'::regclass) |
| Trigger Name | Targets | On Event | Timing | Condition | Order | Orientation | Description |
|---|