Difference between revisions of "Public.map (table)"
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | public.map |- |} {| border="1" cellpadding="5" cellspacing="0" style="border...) |
|||
| Line 20: | Line 20: | ||
|- | |- | ||
| mapid | | mapid | ||
| − | | | + | | integer |
| not null | | not null | ||
| | | | ||
| Line 27: | Line 27: | ||
|- | |- | ||
| mapname | | mapname | ||
| − | | | + | | varchar(40) |
| not null | | not null | ||
| | | | ||
| Line 34: | Line 34: | ||
|- | |- | ||
| mapbackground | | mapbackground | ||
| − | | | + | | varchar(256) |
| null | | null | ||
| | | | ||
| Line 41: | Line 41: | ||
|- | |- | ||
| mapowner | | mapowner | ||
| − | | | + | | varchar(64) |
| not null | | not null | ||
| | | | ||
| Line 48: | Line 48: | ||
|- | |- | ||
| mapcreatetime | | mapcreatetime | ||
| − | | | + | | timestamp without time zone |
| not null | | not null | ||
| | | | ||
| Line 55: | Line 55: | ||
|- | |- | ||
| mapaccess | | mapaccess | ||
| − | | | + | | char(6) |
| not null | | not null | ||
| | | | ||
| Line 62: | Line 62: | ||
|- | |- | ||
| userlastmodifies | | userlastmodifies | ||
| − | | | + | | varchar(64) |
| not null | | not null | ||
| | | | ||
| Line 69: | Line 69: | ||
|- | |- | ||
| lastmodifiedtime | | lastmodifiedtime | ||
| − | | | + | | timestamp without time zone |
| not null | | not null | ||
| | | | ||
| Line 76: | Line 76: | ||
|- | |- | ||
| mapscale | | mapscale | ||
| − | | | + | | double precision |
| null | | null | ||
| | | | ||
| Line 83: | Line 83: | ||
|- | |- | ||
| mapxoffset | | mapxoffset | ||
| − | | | + | | integer |
| null | | null | ||
| | | | ||
| Line 90: | Line 90: | ||
|- | |- | ||
| mapyoffset | | mapyoffset | ||
| − | | | + | | integer |
| null | | null | ||
| | | | ||
| Line 97: | Line 97: | ||
|- | |- | ||
| maptype | | maptype | ||
| − | | | + | | char(1) |
| null | | null | ||
| | | | ||
| Line 104: | Line 104: | ||
|- | |- | ||
| mapwidth | | mapwidth | ||
| − | | | + | | integer |
| not null | | not null | ||
| | | | ||
| Line 111: | Line 111: | ||
|- | |- | ||
| mapheight | | mapheight | ||
| − | | | + | | integer |
| not null | | not null | ||
| | | | ||
Revision as of 15:43, 7 August 2009
wikibot
| Table | public.map |
| Column | Data Type | Nullable | Default | PK | Index |
| mapid | integer | not null | pk_mapid | ||
| mapname | varchar(40) | not null | |||
| mapbackground | varchar(256) | null | |||
| mapowner | varchar(64) | not null | |||
| mapcreatetime | timestamp without time zone | not null | |||
| mapaccess | char(6) | not null | |||
| userlastmodifies | varchar(64) | not null | |||
| lastmodifiedtime | timestamp without time zone | not null | |||
| mapscale | double precision | null | |||
| mapxoffset | integer | null | |||
| mapyoffset | integer | null | |||
| maptype | char(1) | null | |||
| mapwidth | integer | not null | |||
| mapheight | integer | not null |
| Detail Table | Column | Referencing Column |
| public.element | mapid | mapid |
