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 vote88 views1 answer
CREATE MULTIPLE FK
SQL
0 vote101 views1 answer
Mysql undo delete
SQL
1 vote98 views1 answer
Store select query result in variable sql server
SQL
5 votes112 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
0 vote157 views1 answer
Sql ssrs
SQL
1 vote115 views1 answer
Sql server today minus n
SQL
0 vote107 views2 answers
How to update the multiple rows in sql
SQL
0 vote99 views4 answers
Restart MySQL
SQL
0 vote110 views1 answer
Grant privileges mysql to database 1064
SQL
0 vote117 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL