semi
Tables (9)
animal
- animal_num — NUMBER — Primary key
- animal_name — VARCHAR2(50) — NOT NULL
- animal_age — NUMBER — NOT NULL
- animal_race — VARCHAR2(50) — NOT NULL
- animal_gender — VARCHAR2(50) — NOT NULL
- animal_type — VARCHAR2(50) — NOT NULL
- animal_image — varchar(100)
board_comment
- comment_num — NUMBER — Primary key
- comment_text — VARCHAR2(500)
- comment_boardNum — NUMBER
- comment_like — NUMBER
- board_num — NUMBER — Foreign key → map_board.board_num
- member_num (comment_writer) — NUMBER — Foreign key → member.member_num — NOT NULL
friend
- friend_num — NUMBER — Primary key
- request_wait — VARCHAR2(5)
- request_accept — VARCHAR2(5)
- member_num (friend_request) — NUMBER — Foreign key → member.member_num — NOT NULL
- member_num (friend_response) — NUMBER — Foreign key → member.member_num — NOT NULL
map_board
- board_num — NUMBER — Primary key
- member_num (board_writer) — NUMBER — Foreign key → member.member_num — NOT NULL
- board_title — VARCHAR2(50) — NOT NULL
- board_head — VARCHAR2(50)
- board_hit — NUMBER
- board_like — NUMBER
- board_regdate — DATE
- board_file — VARCHAR2(50)
- board_text — VARCHAR2(1500)
- board_area — VARCHAR(50)
map_board_like
- board_num — NUMBER — Foreign key → map_board.board_num
- member_num — NUMBER — Foreign key → member.member_num — NOT NULL
member
- member_num — NUMBER — Primary key — NOT NULL
- 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_id — VARCHAR(50) — NOT NULL
- member_pwd — VARCHAR(50) — NOT NULL
- animal_num (animal_num1) — NUMBER — Foreign key → animal.animal_num
- animal_num (animal_num2) — NUMBER — Foreign key → animal.animal_num
- animal_num (animal_num3) — NUMBER — Foreign key → animal.animal_num
message
- message_num — NUMBER — Primary key
- message_content — varchar(2000)
- member_num (message_request) — NUMBER — Foreign key → member.member_num — NOT NULL
- member_num (message_response) — NUMBER — Foreign key → member.member_num — NOT NULL
qna_board
- qna_num — NUMBER — Primary key
- member_num (qna_writer) — NUMBER — Foreign key → member.member_num — NOT NULL
- qna_title — VARCHAR2(50) — NOT NULL
- qna_head — VARCHAR2(50)
- qna_hit — NUMBER
- qna_regdate — DATE
- qna_update — DATE
- qna_file — VARCHAR2(50)
- qna_content — VARCHAR2(1500)
- qna_pwd — varchar2(50) — NOT NULL
qna_reply
- qna_rno — number(7) — Primary key
- qna_rewriter — varchar2(30) — NOT NULL
- qna_recont — varchar2(1000) — NOT NULL
- qna_redate — DATE
- qna_reupdate — DATE
- qna_num (qna_bno) — NUMBER — Foreign key → qna_board.qna_num