Difference between revisions of "Public.service (table)"
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | public.service |- |} {| border="1" cellpadding="5" cellspacing="0" style="bo...) |
|||
| Line 20: | Line 20: | ||
|- | |- | ||
| serviceid | | serviceid | ||
| − | | | + | | integer |
| not null | | not null | ||
| | | | ||
| Line 27: | Line 27: | ||
|- | |- | ||
| servicename | | servicename | ||
| − | | | + | | varchar(32) |
| not null | | not null | ||
| | | | ||
Revision as of 14:44, 7 August 2009
wikibot
| Table | public.service |
| Column | Data Type | Nullable | Default | PK | Index |
| serviceid | integer | not null | pk_serviceid | ||
| servicename | varchar(32) | not null |
| Detail Table | Column | Referencing Column |
| public.ifservices | serviceid | serviceid |
| public.outages | serviceid | serviceid |