Advertisement
Guest User

Untitled

a guest
Apr 21st, 2022
46
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.38 KB | None | 0 0
  1.         CREATE TABLE IF NOT EXISTS pocket (
  2.             pocket_id INTEGER PRIMARY KEY,
  3.             pocket_num TEXT UNIQUE NOT NULL
  4.             );
  5.  
  6.         CREATE TABLE IF NOT EXISTS item (
  7.             item_id INTEGER PRIMARY KEY,
  8.             item_num TEXT UNIQUE NOT NULL,
  9.             pocket_id INTEGER,
  10.             FOREIGN KEY(pocket_id) REFERENCES pocket(pocket_id)
  11.             );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement