Is this right, Im trying to create 2 tables (ACTIVITY, COMPANY) so that only 1 company is linked to an activity.
CREATE TABLE COMPANY
(
C_ID INT NOT NULL AUTO_INCREMENT,
C_NAME VARCHAR(20),
C_CITY VARCHAR(20),
C_STATE VARCHAR(10),
C_DESC TEXT,
RATIONALE TEXT,
contact_NAME VARCHAR(20),
contact_PHONE VARCHAR(15),
contact_EMAIL VARCHAR(20),
MEDIVAS VARCHAR(20),
PRIMARY KEY (C_ID)
);
CREATE TABLE ACTIVITY
(
A_ID INT NOT NULL AUTO_INCREMENT,
C_NUMBER INT NOT NULL,
A_DATE VARCHAR(20),
A_DESC TEXT,
FOREIGN_KEY (C_NUMBER)
REFRENCES COMPANY(C_ID),
PRIMARY KEY (A_ID)
);
