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 vote283 views1 answer
T-sql check if data exists
SQL
1 vote332 views2 answers
This month mysql where
SQL
11 votes281 views1 answer
Ddl materialized view
SQL
0 vote303 views1 answer
Sql if clause within where clause
SQL
7 votes289 views2 answers
Add column table pl sql
SQL
0 vote295 views1 answer
Sql delimiter to columns
SQL
0 vote311 views1 answer
Sql delete caracter list
SQL
0 vote307 views1 answer
Ubuntu stop mysql from starting on boot
SQL
5 votes298 views1 answer
Oracle nls instance
SQL
22 votes288 views4 answers
Mysql date format
SQL