| DbWrench Documentation: MRE |
| Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
| deptos | (Table) |
| Columns | |||||||
| PK | Name | Data Type | NULLs | A/N | Default | Comment | FK |
|
| deptoID | Integer |
| depto.ID | |||
| nombre | VarChar(50) |
| Nombre (p.listados) | ||||
| descripcion | Text |
| Descripcion | ||||
| empreID | Integer |
| empresa.ID |
|
|||
| tiendID | Integer |
| Tienda.ID |
|
|||
| bodegID | Integer |
| 0 | Bodega.ID |
|
||
| Indexes (none) |
| Foreign Keys | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_deptos_bodegas | info.bodegas | info.deptos | bodegID | bodegID |
| fk_deptos_empresas | info.empresas | info.deptos | empreID | empreID |
| fk_deptos_tiendas | info.tiendas | info.deptos | tiendID | tiendID |
| Parent Relations (none) |
| Triggers (none) |
| Used in Diagrams |
| Diagram Name |
| Info |