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

0 vote273 views1 answer
Sql alchemy escape ; in insert statement
SQL
4 votes193 views2 answers
Oracle unlock account
SQL
3 votes173 views1 answer
Sql case update
SQL
4 votes166 views1 answer
Sql any
SQL
0 vote164 views1 answer
SQL Server format datetime
SQL
6 votes174 views2 answers
Postgresql restore from dump
SQL
1 vote175 views1 answer
How to see logical reads in sql server
SQL
0 vote222 views2 answers
Find lowest number in sql
SQL
12 votes168 views4 answers
SQL Where
SQL
1 vote193 views1 answer
Postgresql not in
SQL