iso18626_messages

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
iso18626_message_id INT 10 null

Internal message number

iso18626_request_id INT 10 null
iso18626_requests.iso18626_request_id iso18626_messages_rfk C

Associated ISO18626 request

content MEDIUMTEXT 16777215 null

Message content (XML)

type enum('request', 'requestConfirmation', 'supplyingAgencyMessage', 'supplyingAgencyMessageConfirmation', 'requestingAgencyMessage', 'requestingAgencyMessageConfirmation') 35 null

ISO18626 message type

timestamp TIMESTAMP 19 current_timestamp()

Indexes

Constraint Name Type Sort Column(s)
iso18626_messages_s_pk Primary key Asc iso18626_message_id
iso18626_messages_rfk Performance Asc iso18626_request_id
PRIMARY Must be unique Asc iso18626_message_id

Relationships