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 vote267 views0 answer
SQL
0 vote307 views1 answer
Query params sql insert python f string
SQL
0 vote284 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
0 vote313 views1 answer
Materialized view redshift
SQL
1 vote319 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
0 vote330 views1 answer
How to find sql server installation folder
SQL
0 vote301 views4 answers
Change schema in sql server
SQL
0 vote295 views1 answer
Search In the Data using ObjectName
SQL
0 vote291 views1 answer
Storing RGBA in mysql db
SQL
3 votes297 views1 answer
Mssql remove column
SQL