Main Tables Views Indexes Constraints Triggers Procedures Functions Packages Sanity check Index

ACS3 Data Model

Description Columns Query Constraints Triggers

TICKET_CODES

Columns

NameTypeNullableInsertableUpdatableDeletableComment
CODE_SETVARCHAR2(20.0)NYESYESYES 
CODE_IDNUMBER(38)NNONONO 
CODE_TYPEVARCHAR2(20.0)YNONONO 
CODEVARCHAR2(100.0)NNONONO 
CODE_LONGVARCHAR2(400.0)NNONONO 
CODE_SEQNUMBER(38)NNONONO 
CODE_HELPVARCHAR2(4000.0)YNONONO 

Query:

select tcs.code_set,
        tci.code_id,
        tci.code_type,
        tci.code,
        tci.code_long,
        tci.code_seq,
        tci.code_help
  from ticket_codes_i tci, ticket_code_sets tcs
  where tcs.code_id = tci.code_id


Generated by OraSchemaDoc, (c) Aram Kananov, 2002