[dbsrgits/SQL-Translator.git] / t / data / oracle / schema_with_options.yaml

---
schema:
  procedures: {}
  tables:
    d_operator:
      constraints:
        - deferrable: 1
          expression: ''
          fields:
            - id_operator
          match_type: ''
          name: ''
          on_delete: ''
          on_update: ''
          options: []
          reference_fields: []
          reference_table: ''
          type: PRIMARY KEY
      fields:
        id_operator:
          data_type: integer
          default_value: ~
          extra: {}
          is_auto_increment: 1
          is_nullable: 0
          is_primary_key: 1
          is_unique: 0
          name: id_operator
          order: 58
          size:
            - 0
        name:
          data_type: varchar
          default_value: ~
          extra: {}
          is_nullable: 0
          is_primary_key: 0
          is_unique: 0
          name: name
          order: 59
          size:
            - 0
      indices:
        - fields:
            - name
          name: operator_name
          options:
            - TABLESPACE: INDX
          type: NORMAL
      name: d_operator
      options:
        - TABLESPACE: DATA
      order: 11
Commit	Line	Data
bdd8e79a	1	---
	2	schema:
	3	procedures: {}
	4	tables:
	5	d_operator:
	6	constraints:
	7	- deferrable: 1
	8	expression: ''
	9	fields:
	10	- id_operator
	11	match_type: ''
	12	name: ''
	13	on_delete: ''
	14	on_update: ''
	15	options: []
	16	reference_fields: []
	17	reference_table: ''
	18	type: PRIMARY KEY
	19	fields:
	20	id_operator:
	21	data_type: integer
	22	default_value: ~
	23	extra: {}
	24	is_auto_increment: 1
	25	is_nullable: 0
	26	is_primary_key: 1
	27	is_unique: 0
	28	name: id_operator
	29	order: 58
	30	size:
	31	- 0
	32	name:
	33	data_type: varchar
	34	default_value: ~
	35	extra: {}
	36	is_nullable: 0
	37	is_primary_key: 0
	38	is_unique: 0
	39	name: name
	40	order: 59
	41	size:
	42	- 0
	43	indices:
	44	- fields:
	45	- name
	46	name: operator_name
	47	options:
	48	- TABLESPACE: INDX
	49	type: NORMAL
	50	name: d_operator
	51	options:
	52	- TABLESPACE: DATA
	53	order: 11