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 vote170 views1 answer
Query to insert image
SQL
10 votes147 views4 answers
Else if mysql
SQL
1 vote138 views1 answer
Oracle stop job
SQL
0 vote152 views2 answers
Athena drop partition
SQL
1 vote138 views1 answer
What is in condition in sql
SQL
3 votes146 views1 answer
V$session not found in oracle
SQL
0 vote137 views1 answer
Copy Table from SQL to CSV
SQL
17 votes165 views6 answers
MySQL ORDER BY
SQL
0 vote167 views1 answer
Time data type in mysql
SQL
0 vote134 views2 answers
Sqlite unix timestamp
SQL