Skip to content

Instantly share code, notes, and snippets.

@fifiteen82726

fifiteen82726/gist:d0b6fdc43caef587bb7b

Created May 5, 2015 11:51
Show Gist options
  • Save fifiteen82726/d0b6fdc43caef587bb7b to your computer and use it in GitHub Desktop.
Save fifiteen82726/d0b6fdc43caef587bb7b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.sql
CREATE TABLE DIRECTOR(
DIR_NUM VARCHAR(20) NOT NULL,
DIR_LNAME VARCHAR(30) NULL,
DIR_DOB DATETIME NULL,
PRIMARY KEY (DIR_NUM),
)
CREATE TABLE PLAY(
PLAY_CODE VARCHAR(20) NOT NULL,
PLAY_NAME VARCHAR(50) NULL,
DIR_NUM VARCHAR(20) NULL,
PRIMARY KEY(PLAY_CODE),
FOREIGN KEY (DIR_NUM) REFERENCES DIRECTOR(DIR_NUM),
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment