====== 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