6 lines
350 B
SQL
6 lines
350 B
SQL
CREATE TABLE IF NOT EXISTS directory (
|
|
number INTEGER PRIMARY KEY NOT NULL, -- This is the directory phone number
|
|
name VARCHAR(255) NOT NULL, -- This is the VARCHAR(255) of the entry, set by the user.
|
|
route INTEGER NOT NULL, -- This is the ID of the route that owns this entry. Foreign key to routes.id
|
|
FOREIGN KEY(route) REFERENCES routes(id)
|
|
); |