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