| DbWrench Documentation: MRE |
| Home | | | Tables | | | Schemas | | | Diagrams | | | Foreign Keys | | | Indexes |
| racks | (Table) |
| Columns | |||||||
| PK | Name | Data Type | NULLs | A/N | Default | Comment | FK |
|
| racksID | Integer |
| Rack.ID | |||
| zonasID | Integer |
| Zona.ID |
|
|||
| pasillo | VarChar(20) |
| Pasillo.ID | ||||
| nombre | VarChar(100) |
| nombre, codigo o descrip este rack | ||||
| fecha | Date |
| 2007-06-01 | fecha en que se habilito | |||
| bloquID | Integer |
| nblok.ID |
|
|||
| Indexes (none) |
| Foreign Keys | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_racks_bloqueos | mantenimiento.bloqueos | inventarios.racks | bloquID | bloquID |
| fk_racks_zonas | inventarios.zonas | inventarios.racks | zonasID | zonasID |
| Parent Relations | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_celdas_racks | inventarios.racks | inventarios.celdas | racksID | racksID |
| Triggers (none) |
| Used in Diagrams |
| Diagram Name |
| Existencias |