{
	"name": "table/prf/default_field.json",
	"default_field": [
		{
			"field_name": "db_id",
			"constraint": ["GENERATED ALWAYS AS IDENTITY"],
			"field_type": "bigint",
			"add_always": true,
			"info": "Database-global creation id. We can store bigint into Lua and Javascript double up to 2^53 = 9 007 199 254 740 992. This field will be added to the database when creating it using doperation.createTable() if db driver is Postgres. The field is needed for audit log."
		},
		{
			"field_name": "db_modify_id",
			"constraint": ["unique"],
			"field_type": "bigint",
			"add_always": true,
			"info": "Database-global modification id. This field will be added to the database when creating it using doperation.createTable() if db driver is Postgres. The field is needed for audit log."
		},
		{
			"field_name": "record_type",
			"constraint": ["index"],
			"field_type": "varchar",
			"field_length": 20
		},
		{
			"field_name": "record_id",
			"constraint": ["unique"],
			"field_type": "uuid"
		},
		{
			"field_name": "modify_id",
			"constraint": ["unique"],
			"field_type": "uuid"
		},
		{
			"field_name": "create_time",
			"default_function": "NOW()",
			"field_type": "timestamp"
		},
		{
			"field_name": "modify_time",
			"default_function": "NOW()",
			"field_type": "timestamp",
			"add_always": true
		},
		{
			"field_name": "modify_user",
			"field_length": 40,
			"field_type": "varchar"
		},
		{
			"field_name": "json_data",
			"field_type": "jsonb"
		}
	],
	"extra_field": [
		{
			"field_name": "json_data.record_id",
			"constraint": ["unique"],
			"field_type": "text"
		},
		{
			"field_name": "json_data.modify_time",
			"field_type": "text"
		},
		{
			"field_name": "json_data.create_user",
			"field_length": 40,
			"field_type": "varchar"
		}
	],
	"add-this": [
		{
			"field_name": "db_version",
			"field_type": "bigint",
			"default_value": 0,
			"info": "Record's modification id. This field will be added to the database when creating it using doperation.createTable() if db driver is postgre. The field is updated on every save."
		}
	]
}
