+alarm_definition = Table(
+ "alarmDefinition",
+ metadata,
+ Column("updatetime", DateTime),
+ Column("createtime", DateTime),
+
+ Column("alarmDefinitionId", String(255), primary_key=True),
+ Column("alarmName", String(255), unique=True),
+ Column("alarmLastChange", String(255)),
+ Column("alarmChangeType", String(255)),
+ Column("alarmDescription", String(255)),
+ Column("proposedRepairActions", String(1024)),
+ Column("clearingType", String(255)),
+ Column("managementInterfaceId", String(255)),
+ Column("pkNotificationField", String(255))
+)
+
+alarm_dictionary = Table(
+ "alarmDictionary",
+ metadata,
+ Column("updatetime", DateTime),
+ Column("createtime", DateTime),
+
+ Column("id", String(255), primary_key=True),
+ Column("entityType", String(255), unique=True),
+ Column("alarmDictionaryVersion", String(255)),
+ Column("alarmDictionarySchemaVersion", String(255)),
+ Column("vendor", String(255)),
+ Column("managementInterfaceId", String(255)),
+ Column("pkNotificationField", String(255))
+
+ # Column("resourceTypeId", ForeignKey("resourceType.resourceTypeId"))
+)
+
+association_table1 = Table(
+ 'associationAlarmDictAndAlarmDef',
+ metadata,
+ Column("alarmDictionaryId", ForeignKey(
+ 'alarmDictionary.id', ondelete='cascade')),
+ Column("alarmDefinitionId", ForeignKey(
+ 'alarmDefinition.alarmDefinitionId'))
+)
+
+alarm_event_record = Table(
+ "alarmEventRecord",
+ metadata,
+ Column("updatetime", DateTime),
+ Column("createtime", DateTime),
+ Column("hash", String(255)),
+
+ Column("alarmEventRecordId", String(255), primary_key=True),
+ Column("resourceTypeId", ForeignKey("resourceType.resourceTypeId")),
+ Column("resourceId", ForeignKey("resource.resourceId")),
+ Column("alarmDefinitionId", ForeignKey(
+ "alarmDefinition.alarmDefinitionId")),
+ Column("probableCauseId", String(255)),
+ Column("perceivedSeverity", Integer),
+ Column("alarmRaisedTime", String(255)),
+ Column("alarmChangedTime", String(255)),
+ Column("alarmAcknowledgeTime", String(255)),
+ Column("alarmAcknowledged", String(255)),
+)
+
+alarm_probable_cause = Table(
+ "probableCause",
+ metadata,
+ Column("updatetime", DateTime),
+ Column("createtime", DateTime),
+ Column("hash", String(255)),
+
+ Column("probableCauseId", String(255), primary_key=True),
+ Column("name", String(255)),
+ Column("description", String(255)),
+)
+
+alarm_subscription = Table(
+ "alarmSubscription",