1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
| portal_bus:
service: { type: integer, required: true, primaryKey: true }
network: { type: integer, required: true, primaryKey: true }
env: { type: varchar(10), required: true, foreignTable: portal_environment, foreignReference: name }
application: { type: varchar(32), required: true }
iam_ref: { type: varchar(3), required: true, foreignTable: portal_iam , foreignReference: ref }
module: { type: varchar(50) }
description: { type: varchar(255) }
status: { type: varchar(5), required: true }
entity: { type: varchar(32), required: true }
creator: { type: varchar(80), required: true }
modifier: { type: varchar(80) }
created: { type: timestamp, required: true }
modified: { type: timestamp }
reference: { type: varchar(32) }
active: { type: boolean, required: true, default: 0 }
tags: { type: varchar(20) , foreignTable: portal_label, foreignReference: name }
alias: { type: varchar(32), required: true }
prefix: { type: varchar(255) }
portal_bus_label:
bus_id: { type: integer, foreignTable: portal_bus, references: {service, network}, required: true, primaryKey: true, onDelete: cascade }
label_id: { type: varchar(20), foreignTable: portal_label, foreignReference: id, required: true, primaryKey: true, onDelete: cascade }
|
Partager