Table of Contents



pears.DebtorText

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Description

Contains text of different stages of severity of Debt Chasing letters.

Columns

Column Type Null Default Comment
id char(1) NOT NULL
Header long varchar NULL
Severity1 long varchar NULL
Severity2 long varchar NULL
Severity3 long varchar NULL

Primary Key

Foreign Keys

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."DebtorText"
-- Table comment: Contains text of different stages of severity of Debt Chasing letters.
-- Statement count: 2
 
CREATE TABLE "pears"."DebtorText" (
    "id"                             CHAR(1) NOT NULL
   ,"Header"                         long VARCHAR NULL
   ,"Severity1"                      long VARCHAR NULL
   ,"Severity2"                      long VARCHAR NULL
   ,"Severity3"                      long VARCHAR NULL
   ,PRIMARY KEY ("id" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."DebtorText" IS 
	'Contains text of different stages of severity of Debt Chasing letters.'
GO