pears.TagPersonExpiryStatus

• taglocation, tagid, PersonStatus

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."TagPersonExpiryStatus"
-- Table comment: 
-- Statement count: 1
 
CREATE TABLE "pears"."TagPersonExpiryStatus" (
    "taglocation"                    CHAR(3) NOT NULL
   ,"tagid"                          CHAR(3) NOT NULL
   ,"PersonStatus"                   CHAR(4) NOT NULL
   ,PRIMARY KEY ("taglocation" ASC,"tagid" ASC,"PersonStatus" ASC) 
)
GO