Contents

\connect postgres

drop database if exists fox;
create database fox;

\connect fox

create unlogged table accounts (
  id integer generated by default as identity primary key,
  i integer
);

create unlogged table users (
  id integer primary key references accounts(id),
  name text not null
);

create unlogged table jobs (
  id integer primary key references accounts(id),
  name text not null
);
  
create unlogged table infos (
  id integer generated by default as identity primary key,
  job_id integer references jobs(id),
  info text not null
);

Version data entries

16 entries across 16 versions & 1 rubygems

Version	Path
fixture_fox-0.2.12	examples/inherit.sql
fixture_fox-0.2.11	examples/inherit.sql
fixture_fox-0.2.10	examples/inherit.sql
fixture_fox-0.2.9	examples/inherit.sql
fixture_fox-0.2.8	examples/inherit.sql
fixture_fox-0.2.7	examples/inherit.sql
fixture_fox-0.2.6	examples/inherit.sql
fixture_fox-0.2.5	examples/inherit.sql
fixture_fox-0.2.4	examples/inherit.sql
fixture_fox-0.2.3	examples/inherit.sql
fixture_fox-0.2.2	examples/inherit.sql
fixture_fox-0.2.1	examples/inherit.sql
fixture_fox-0.2.0	examples/inherit.sql
fixture_fox-0.1.3	examples/inherit.sql
fixture_fox-0.1.2	examples/inherit.sql
fixture_fox-0.1.1	examples/inherit.sql