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

7 votes287 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
0 vote238 views1 answer
Oracle sql developer script output limit
SQL
1 vote333 views1 answer
Oracle columns table
SQL
0 vote272 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
-1 vote303 views2 answers
Sql truncate number
SQL
0 vote275 views1 answer
Call function sql oracle
SQL
1 vote318 views1 answer
Nullif postgresql
SQL
1 vote295 views1 answer
Postgres cast as currency format
SQL
6 votes285 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
3 votes290 views1 answer
Stpop start psql server
SQL