TERMS

Tables (3)

TERMS (TEARMS)

  • SEQ (PK) — NUMBER — Primary key — NOT NULL
  • CORP (Field4) — VARCHAR2
  • CATEGORY (Field) — VARCHAR2
  • CREATE_TIME (Field3) — DATE

TERMS (TEARMS2)

  • SEQ (PK) — NUMBER — Primary key — NOT NULL
  • CORP (Field4) — VARCHAR2
  • CATEGORY (Field) — VARCHAR2
  • TYPE (Field6) — VARCHAR2
  • CONTENT (Field2) — CLOB
  • VERSION (Field7) — NUMBER
  • CREATE_TIME (Field3) — DATE
  • UPDATE_TIME (Field8) — DATE
  • EFFECTIVE_TIME (Field9) — DATE
  • MEN_OF_CHARGE (Field5) — VARCHAR2

TERMS_CHANGE_HISTORY

  • SEQ (PK) — Primary key — NOT NULL
  • TERMS_SEQ (FK) — NUMBER — Foreign key → TERMS.SEQ — NOT NULL
  • TYPE (Field) — VARCHAR2
  • VERSION (Field3) — NUMBER
  • EFFECTIVE_DATE (Field4) — DATE
  • UPDATE_TIME (Field5) — DATE
  • CONTENT (Field2) — CLOB
  • MEN_OF_CHARGE (Field6) — VARCHAR2