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 vote304 views1 answer
ORA-01400
SQL
0 vote229 views1 answer
Sql add calculated column
SQL
6 votes619 views3 answers
Sql select last id
SQL
1 vote229 views1 answer
Increase existing date in sql oracle
SQL
0 vote226 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
0 vote207 views1 answer
Lister les index d'une table oracle
SQL
10 votes264 views4 answers
Sql server pagination
SQL
0 vote241 views1 answer
Postgres list all stored procedures query
SQL
0 vote259 views2 answers
Suse Linux restart MySQL
SQL
0 vote229 views1 answer
Teller stamp , bmo , PDF
SQL