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