Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS pocket (
- pocket_id INTEGER PRIMARY KEY,
- pocket_num TEXT UNIQUE NOT NULL
- );
- CREATE TABLE IF NOT EXISTS item (
- item_id INTEGER PRIMARY KEY,
- item_num TEXT UNIQUE NOT NULL,
- pocket_id INTEGER,
- FOREIGN KEY(pocket_id) REFERENCES pocket(pocket_id)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement