TEST

Tables (9)

member

  • member_no — number
  • member_id — varchar2(20) — NOT NULL
  • member_pw — varchar2(20) — NOT NULL
  • member_nick — varchar2(20) — NOT NULL
  • member_join — date — NOT NULL

qna_board

  • board_no — number
  • board_writer — not — NOT NULL
  • board_title — varchar2(240) — NOT NULL
  • board_content — varchar2(4000) — NOT NULL
  • regist_time — date — NOT NULL
  • vote — number — NOT NULL

qna_opinion

  • opinion_no — number
  • opinion_content — varchar2(240) — NOT NULL
  • regist_time — date — NOT NULL
  • board_no — references
  • opinion_writer — references

qna_tmp_file

  • file_no — number
  • upload_name — varchar2(256) — NOT NULL
  • save_name — varchar2(256) — NOT NULL
  • file_size — number
  • file_type — varchar2(256)
  • board_no — references

qna_vote

  • vote_no — number
  • board_no — references
  • member_id — references

tip_board

  • board_no — number
  • board_writer — not — NOT NULL
  • board_title — varchar2(240) — NOT NULL
  • board_content — varchar2(4000) — NOT NULL
  • regist_time — date — NOT NULL
  • vote — number — NOT NULL
  • start_date — date — NOT NULL
  • end_date — date — NOT NULL

tip_opinion

  • opinion_no — number
  • opinion_text — varchar2(240) — NOT NULL
  • regist_time — date — NOT NULL
  • board_no — references
  • opinion_writer — references

tip_tmp_file

  • file_no — number
  • upload_name — varchar2(256) — NOT NULL
  • save_name — varchar2(256) — NOT NULL
  • file_size — number
  • file_type — varchar2(256)
  • board_no — references

tip_vote

  • vote_no — number
  • board_no — not — NOT NULL
  • member_no — not — NOT NULL