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)