parent/child table or not?
hi
i don't know if i should use a parent/child relation.
i would like to manage ADVERTISEMENT and it's answer...
so i could something like
Code:
CREATE TABLE ADVERTISEMENT(
ADVERTISEMENT_ID INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
TITLE VARCHAR(64) NOT NULL,
DESCRIPTION VARCHAR(400) NOT NULL,
STATE_ID INT NOT NULL
DATE_CREATION DATE,
USERS_ID INT
);
CREATE TABLE ANSWER(
ANSWER_ID INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
TEXT VARCHAR(400) NOT NULL,
DATE_CREATION DATE,
PARENT_ID INT,
USERS_ID INT
);
i will use all field...
or i can use same table like
Code:
CREATE TABLE ADVERTISEMENT(
ADVERTISEMENT_ID INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
TITLE VARCHAR(64) NOT NULL,
DESCRIPTION VARCHAR(400) NOT NULL,
STATE_ID INT NOT NULL
DATE_CREATION DATE,
USERS_ID INT,
PARENT_ID INT
);
any suggestion?
thanks