pears.places
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Description
Place - region and country names. Used for address tidying.
Columns
| Column | Type | Null | Default | Comment |
|---|---|---|---|---|
| PLACE | varchar(255) | NULL | ||
| CODE | varchar(1) | NULL |
Primary Key
- No primary key found in generated SQL.
Foreign Keys
- No outgoing foreign keys found.
Referenced By
- No incoming foreign keys found.
Indexes
- No indexes found.
Triggers
- No triggers found.
Original SQL
-- IQX database structure split by table -- Source: IQXDatabaseStructure - with comments.sql -- Table: "pears"."places" -- Table comment: Place - region and country names. Used for address tidying. -- Statement count: 2 CREATE TABLE "pears"."places" ( "PLACE" VARCHAR(255) NULL ,"CODE" VARCHAR(1) NULL INLINE 1 PREFIX 1 ) GO COMMENT ON TABLE "pears"."places" IS 'Place - region and country names. Used for address tidying.' GO