parent/child table or not?

[marcpirat]

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

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

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