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

3 votes313 views2 answers
Oracle for loop
SQL
3 votes330 views1 answer
Oracle show trigger code
SQL
0 vote359 views1 answer
Mysql change default collation
SQL
0 vote362 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
3 votes367 views1 answer
Laravel paginate raw sql
SQL
1 vote370 views1 answer
Sql insert for each distinct value
SQL
0 vote322 views1 answer
IIF
SQL
6 votes333 views1 answer
Oracle trigger after logon on schema
SQL
2 votes332 views3 answers
How to get second highest salary in each department in sql
SQL
3 votes343 views2 answers
Postgres alter table owner
SQL