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

11 votes311 views1 answer
How to get ddl for materialized view
SQL
25 votes344 views6 answers
Import mysql database command line
SQL
33 votes392 views6 answers
Sql delete
SQL
0 vote365 views1 answer
How to locate pg_hba.conf file
SQL
0 vote360 views1 answer
Select the date 30 days less that the todays date sql request
SQL
2 votes360 views2 answers
Sqlalchemy return id after insert
SQL
0 vote313 views1 answer
How to to get current date and time in sql
SQL
6 votes300 views1 answer
Oracle trigger after connect
SQL
0 vote325 views4 answers
Best data type to represent money in mysql
SQL
0 vote327 views1 answer
Sql select max value for each group
SQL