|
DbWrench Documentation: PSLID 3.0 |
| Home | Tables | Schemas | Diagrams | Foreign Keys | Indexes |
|
Table: tbllaboratory |
| Columns | |||||||
| PK | Name | Data Type | NULLs | A/N | Default | Comment | FK |
|
| laboratory_id | Integer | |||||
| lab_name | VarChar(30) |
| |||||
| lab_address | VarChar(150) |
| |||||
| lab_email_add | VarChar(30) |
| |||||
| lab_phone_num | VarChar(30) |
| |||||
| Indexes | ||||
| Name | Table | Columns | Unique | Clustered |
| Foreign Keys | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| Parent Relations | ||||
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| tblresch_tbllab | tbllaboratory | tblresearcher | laboratory_id | laboratory_id |
| Triggers | |||||||
| Name | Table | On Delete | On Insert | On Update | Execute | For Each | SQL |
| Used in Diagrams |
| Diagram Name |
| Take II |