Sql table to store status

CREATE TABLE status
(
  id integer PRIMARY KEY,
  name TEXT NOT NULL,
  next_status Integer references status
);

insert into status(id, name, next_status)
values 
(1,'init', 2),
(2,'waiting ror price approve', 3),
(3,'sent', 4),
(4,'accepted', 5),
(5,'finished', null);

Source: stackoverflow.com

Similar codes

2 votes195 views1 answer
How to make multiple keys as primary in bdms
SQL
0 vote272 views1 answer
Shortcut run sql pgadmin
SQL
13 votes187 views2 answers
Get tables in database sql
SQL
11 votes183 views1 answer
Get ddl materialized view oracle
SQL
2 votes181 views1 answer
Sql server case sensitive search
SQL
4 votes187 views1 answer
Phone number sql
SQL
0 vote219 views1 answer
Sqlite get date only
SQL
0 vote176 views1 answer
Tsql delete all rows
SQL
0 vote180 views1 answer
Docker export psql sql
SQL
0 vote172 views1 answer
Sql comparison operators
SQL