Petopia

Tables (4)

Board

  • b_seq — Primary key — NOT NULL
  • div_seq — NOT NULL
  • b_subject
  • b_writer
  • b_content
  • b_wdate
  • b_file
  • b_image

Member

  • m_seq — int(3) — Primary key — NOT NULL
  • m_id — varchar(13) — NOT NULL
  • m_nickname — varchar(12) — NOT NULL
  • m_name — varchar(20) — NOT NULL
  • m_password — varchar(30) — NOT NULL
  • m_email — varchar(100) — NOT NULL
  • m_addr — varchar(100) — NOT NULL
  • m_phone — varchar(15) — NOT NULL
  • m_age — int(3) — NOT NULL
  • m_date — datetime — NOT NULL
  • m_grade — varchar(10) — NOT NULL
  • m_point — int(5) — NOT NULL

Pet_Info

  • 회원번호 (p_seq) — int(3) — Primary key — NOT NULL
  • m_seq — int(3) — Foreign key → Member.m_seq — NOT NULL
  • p_name — varchar(20) — NOT NULL
  • p_age — int(3) — NOT NULL
  • p_birth — datetime — NOT NULL
  • p_species — varchar(20)
  • p_gender — boolean
  • p_image — varchar(100)

Pro_Card

  • m_seq — int(3) — Foreign key → Member.m_seq — NOT NULL
  • pro_comment
  • pro_image