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