semi
Tables (6)
animal
- animal_name — VARCHAR2(50) — NOT NULL
- animal_age — NUMBER — NOT NULL
- animal_race — VARCHAR2(50) — NOT NULL
- animal_gender — VARCHAR2(50) — NOT NULL
- animal_num — NUMBER
- animal_type — VARCHAR2(50) — NOT NULL
- animal_image — varchar(100)
board_comment
- comment_text — VARCHAR2(500)
- comment_num — NUMBER
- comment_boardNum — NUMBER
- comment_like — NUMBER
- comment_writer — NUMBER
friend
- friend_num — NUMBER
- friend_request — NUMBER
- friend_response — NUMBER
- request_wait — VARCHAR2(5)
- request_accept — VARCHAR2(5)
map_board
- board_num — NUMBER
- board_title — VARCHAR2(50) — NOT NULL
- board_head — VARCHAR2(50)
- board_hit — NUMBER
- board_like — NUMBER
- board_writer — NUMBER
- board_regdate — DATE
- board_file — VARCHAR2(50)
- board_text — VARCHAR2(1500)
- board_area — VARCHAR(50)
member
- member_num — NUMBER
- member_age — NUMBER — NOT NULL
- member_name — VARCHAR2(50) — NOT NULL
- member_phone — VARCHAR2(50) — NOT NULL
- member_email — VARCHAR2(50)
- member_addr1 — VARCHAR2(50) — NOT NULL
- member_addr2 — VARCHAR2(50) — NOT NULL
- member_addr3 — VARCHAR2(50)
- member_self — VARCHAR2(50)
- member_nick — VARCHAR2(50)
- member_gender — VARCHAR2(50) — NOT NULL
- member_animal1 — NUMBER
- member_animal2 — NUMBER
- member_animal3 — NUMBER
- member_id — VARCHAR(50) — NOT NULL
- member_pwd — VARCHAR(50) — NOT NULL
qna_board
- qna_num — NUMBER
- qna_title — VARCHAR2(50) — NOT NULL
- qna_head — VARCHAR2(50)
- qna_hit — NUMBER
- qna_writer — NUMBER
- qna_regdate — DATE
- qna_update — DATE
- qna_file — VARCHAR2(50)
- qna_content — VARCHAR2(1500)
- qna_pwd — varchar2(50) — NOT NULL
- qna_group — number(7)
- qna_step — number(5)
- qna_indent — number(5)