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

1 vote173 views1 answer
Sql server list locks
SQL
1 vote166 views1 answer
Select from one table where not on the other
SQL
21 votes171 views3 answers
Sql average
SQL
0 vote157 views1 answer
Low level operator in dbms
SQL
0 vote166 views1 answer
Sql count null as 0
SQL
1 vote201 views1 answer
Myql find duplicates
SQL
0 vote161 views1 answer
What is SQL data store?
SQL
39 votes182 views5 answers
Sql drop column
SQL
0 vote177 views1 answer
Sql server list user permissions
SQL
1 vote185 views3 answers
Update from select sqlite
SQL