path: root/schema.sql

create schema peeringdb;

create table peeringdb.org (
	id int not null,
	status text not null,
	data jsonb not null,
	created timestamptz not null,
	updated timestamptz not null,
	deleted timestamptz,
	primary key (id)
);

create table peeringdb.net (
	id int not null,
	org_id int not null,
	asn int not null,
	status text not null,
	data jsonb not null,
	created timestamptz not null,
	updated timestamptz not null,
	deleted timestamptz,
	primary key (id)
);

create table peeringdb.ix (
	id int not null,
	org_id int not null,
	status text not null,
	data jsonb not null,
	created timestamptz not null,
	updated timestamptz not null,
	deleted timestamptz,
	primary key (id)
);

create table peeringdb.fac (
	id int not null,
	org_id int not null,
	status text not null,
	data jsonb not null,
	created timestamptz not null,
	updated timestamptz not null,
	deleted timestamptz,
	primary key (id)
);

create table peeringdb.poc (
	id int not null,
	net_id int not null,
	status text not null,
	data jsonb not null,
	created timestamptz not null,
	updated timestamptz not null,
	deleted timestamptz,
	primary key (id)
);

create table peeringdb.ixlan (
	id int not null,
	ix_id int not null,
	status text not null,
	data jsonb not null,
	created timestamptz not null,
	updated timestamptz not null,
	deleted timestamptz,
	primary key (id)
);

create table peeringdb.ixpfx (
	id int not null,
	ixlan_id int not null,
	status text not null,
	data jsonb not null,
	created timestamptz not null,
	updated timestamptz not null,
	deleted timestamptz,
	primary key (id)
);

create table peeringdb.ixfac (
	id int not null,
	ix_id int not null,
	fac_id int not null,
	status text not null,
	data jsonb not null,
	created timestamptz not null,
	updated timestamptz not null,
	deleted timestamptz,
	primary key (id)
);

create table peeringdb.netfac (
	id int not null,
	net_id int not null,
	fac_id int not null,
	status text not null,
	data jsonb not null,
	created timestamptz not null,
	updated timestamptz not null,
	deleted timestamptz,
	primary key (id)
);

create table peeringdb.netixlan (
	id int not null,
	net_id int not null,
	ix_id int not null,
	ixlan_id int not null,
	status text not null,
	data jsonb not null,
	created timestamptz not null,
	updated timestamptz not null,
	deleted timestamptz,
	primary key (id)
);