ReviewSite

Tables (4)

File (Untitled5)

  • file_idx — int — Primary key — NOT NULL
  • post_idx — int
  • file_name — varchar
  • file_real_name — varchar
  • file_size — double
  • file_path — varchar
  • create_dt — date
  • update_dt — date
  • delete — int

Post (Untitled2)

  • post_idx — int — Primary key — NOT NULL
  • wrtr_idx — int
  • title — varchar
  • content — varchar
  • url — varchar
  • create_dt — date
  • update_dt — date
  • approval — int
  • delete — int

Reply (Untitled4)

  • reply_key — int — Primary key — NOT NULL
  • post_list — int
  • wrtr_idx — int
  • category_idx — int
  • reply_content — varchar
  • parent — varchar
  • depth — varchar
  • order — varchar
  • delete — int
  • create_dt — date
  • update_dt — date
  • rate — long

User (Untitled)

  • user_idx — int — Primary key — NOT NULL
  • user_id — varchar
  • user_pw — varchar
  • salt — varchar
  • email — varchar
  • nickname — varchar
  • regist_dt — date
  • comment — varchar
  • user_img — varchar
  • role — int
  • update_dt — date — NOT NULL