catPunch
테이블 (15)
FAQ (cat_faq)
- Key (cf_id) — int — 기본 키 — NOT NULL
- Key (u_id) — int — 외래 키 → 유저 정보.Key — NOT NULL
- Field (faq_title) — varchar(50) — NOT NULL
- Field (faq_text) — varchar(2000) — NOT NULL
- Field2 (faq_writedate) — datetime — NOT NULL
- Field3 (faq_update) — datetime
- Field4 (faq_deletedate) — datetime
- Field5 (faq_show) — tinyint(1) — NOT NULL
- Field6 (faq_writer) — varchar(50) — NOT NULL
결제내역 테이블 (cat_payment)
- Key (cp_id) — int — 기본 키 — NOT NULL
- Key (u_id) — int — 외래 키 → 유저 정보.Key — NOT NULL
- Field (fk_cpid) — int — NOT NULL
- Field (pay_sort_1) — int
- Field2 (pay_sort_2) — int
- Field3 (pay_sort_3) — int
- Field4 (pay_amount) — int
- Field5 (pay_date) — datetime
공지사항 (cat_info)
- Key (ci_id) — int — 기본 키 — NOT NULL
- Key (u_id) — int — 외래 키 → 유저 정보.Key — NOT NULL
- Field (info_image) — varchar(50)
- Field2 (info_title) — varchar(50) — NOT NULL
- Field3 (info_text) — varchar(2000) — NOT NULL
- Field4 (info_writedate) — datetime — NOT NULL
- Field5 (info_update) — datetime
- Field (info_deletedate) — datetime
- Field (info_show) — tinyint(1) — NOT NULL
- Field2 (info_notice) — tinyint(1) — NOT NULL
- Field3 (info_viewcount) — int — NOT NULL
- Field4 (info_writer) — varchar(50) — NOT NULL
- Field5 (info_filepath) — varchar(100)
- Field6 (int_imageUrl) — varchar(500)
- Field7 (int_imageName) — varchar(500)
공지사항 댓글 (info_comment)
- Key (ic_id) — int — 기본 키 — NOT NULL
- Key (ci_id) — int — 외래 키 → 공지사항.Key — NOT NULL
- Key (u_id) — int — 외래 키 → 공지사항.Key — NOT NULL
- Field (fk_icid) — int — NOT NULL
- Field (icomment_text) — varchar(2000) — NOT NULL
- Field (icomment_writer) — varchar(20) — NOT NULL
- Field (icomment_writedate) — datetime — NOT NULL
- Field (icomment__update) — datetime
- Field (icomment_deletedate) — datetime
- Field (icomment_show) — tinyint(1) — NOT NULL
보호 고양이 목록 (cat_list)
- Key (c_id) — int — 기본 키 — NOT NULL
- Key (u_id) — int — 외래 키 → 유저 정보.Key — NOT NULL
- Field (cat_adopt) — tinyint(1) — NOT NULL
- Field2 (cat_support) — tinyint(1) — NOT NULL
- Field3 (cat_age) — int — NOT NULL
- Field4 (cat_gender) — tinyint(1) — NOT NULL
- Field5 (cat_name) — varchar(20) — NOT NULL
- Field6 (cat_color) — varchar(20) — NOT NULL
- Field7 (cat_breed) — varchar(20) — NOT NULL
- Field8 (cat_supportok) — tinyint(1) — NOT NULL
- Field (cat_show) — tinyint(1) — NOT NULL
신랑신부찾기 (cat_marriage)
- Key (cm_id) — int — 기본 키 — NOT NULL
- Key (u_id) — int — 외래 키 → 유저 정보.Key — NOT NULL
- Field (marriage_title) — varchar(50) — NOT NULL
- Field (marriage_writer) — varchar(20) — NOT NULL
- Field (marriage_text) — varchar(2000) — NOT NULL
- Field2 (marriage_area) — varchar(2) — NOT NULL
- Field3 (marriage_writedate) — datetime — NOT NULL
- Field4 (marriage_update) — datetime
- Field5 (marriage_deletedate) — datetime
- Field (marriage_show) — tinyint(1) — NOT NULL
- Field2 (marriage_viewcount) — int — NOT NULL
- Field3 (marriage_imageUrl) — varchar(500)
- Field (marriage_imageName) — varchar(500)
신랑신부찾기 댓글 (marriage_comment)
- Key (mc_id) — int — 기본 키 — NOT NULL
- Key (cm_id) — int — 외래 키 → 신랑신부찾기.Key — NOT NULL
- Key (u_id) — int — 외래 키 → 신랑신부찾기.Key — NOT NULL
- Field (fk_mcid) — int — NOT NULL
- Field (mcomment_text) — varchar(2000) — NOT NULL
- Field (mcomment_write) — varchar(20) — NOT NULL
- Field (mcomment_writedate) — datetime — NOT NULL
- Field (mcomment_show) — tinyint(1) — NOT NULL
유저 정보 (cat_user)
- Key (u_id) — int — 기본 키 — NOT NULL
- Field (user_id) — varchar(20) — NOT NULL
- Field (user_password) — varchar(60) — NOT NULL
- Field (user_names) — varchar(20) — NOT NULL
- Field (user_tel) — varchar(20) — NOT NULL
- Field (user_email) — varchar(50) — NOT NULL
- Field (user_zipcode) — varchar(50) — NOT NULL
- Field (user_streetAddr) — varchar(50) — NOT NULL
- Field (user_detailedAddr) — varchar(50) — NOT NULL
- Field (user_role) — varchar(20) — NOT NULL
- Field (user_joindate) — datetime — NOT NULL
- Field (user_show) — tinyint(1) — NOT NULL
일시결제, 정기결제 1회차 (tiesponsorshipvo)
- Key (pay_aid) — varchar(50) — 기본 키 — NOT NULL
- Key (pay_userid) — varchar(100) — 외래 키 → 유저 정보.Key — NOT NULL
- Field (pay_tid) — varchar(50)
- Field (pay_cid) — varchar(50)
- Field2 (pay_sid) — varchar(50)
- Field3 (pay_amount) — varchar(50)
- Field4 (pay_cardinfo) — varchar(50)
- Field5 (pay_itemname) — varchar(50)
- Field (pay_quantity) — int
- Field2 (pay_taxfreeamount) — int
- Field3 (pay_createdate) — date
- Field4 (pay_approvedate) — date
- Field (pay_catname) — varchar(20)
- Field2 (pay_onesorregural) — tinyint(1)
- Field3 (pay_counting) — int
입양 결연 테이블 (cat_adopt)
- Key (ca_id) — int — 기본 키 — NOT NULL
- Key (fk_caid) — int — 기본 키 — NOT NULL
- Key (c_id) — int — 외래 키 → 보호 고양이 목록.Key — NOT NULL
- Key (u_id) — int — 외래 키 → 보호 고양이 목록.Key — NOT NULL
- Field1 (adopt_imageName) — varchar(500)
- Field2 (adopt_imageUrl) — varchar(500)
- Field (catadopt_text) — varchar(2000) — NOT NULL
- Field2 (catadopt_writedate) — datetime
- Field3 (catadopt_update) — datetime
- Field4 (catadopt_deletedate) — datetime
- Field5 (catadopt_show) — tinyint(1) — NOT NULL
입양 후기 (adopt_review)
- Key (r_id) — int — 기본 키 — NOT NULL
- Key (u_id) — int — 외래 키 → 유저 정보.Key — NOT NULL
- Field (review_image) — varchar(50) — 리뷰 이미지
- Field (review_title) — varchar(50) — NOT NULL
- Field2 (review_writer) — varchar(20) — NOT NULL
- Field3 (review_text) — varchar(2000) — NOT NULL
- Field4 (review_writedate) — datetime — DEFAULT_GENERATED
- Field5 (review_update) — datetime
- Field6 (review_deletedate) — datetime
- Field7 (review_show) — tinyint(1) — NOT NULL
- Field (review_notice) — tinyint(1) — NOT NULL
- Field2 (review_viewcount) — int — NOT NULL
- Field3 (review_imageUrl) — varchar(500)
- Field (review_imageName) — varchar(500)
입양 후기 댓글 (review_comment)
- Key (rc_id) — int — 기본 키 — NOT NULL
- Key (r_id) — int — 외래 키 → 입양 후기.Key — NOT NULL
- Key (u_id) — int — 외래 키 → 입양 후기.Key — NOT NULL
- Field (fk_rcid) — int — NOT NULL
- Field (rcomment_text) — varchar(2000) — NOT NULL
- Field (rcomment_writer) — varchar(20) — NOT NULL
- Field (rcomment_writerdate) — datetime — NOT NULL
- Field (rcomment_update) — datetime
- Field (rcomment_deletedate) — datetime
- Field (rcomment_show) — tinyint(1) — NOT NULL
정기결제 2회차 이상 (supportreguralinfo)
- Key (pay_sid) — varchar(100) — 기본 키 — NOT NULL
- Key (pay_aid) — varchar(50) — 외래 키 → 일시결제, 정기결제 1회차.Key — NOT NULL
- Key (pay_userid) — varchar(100) — 외래 키 → 유저 정보.Key — NOT NULL
- Field2 (pay_amount) — varchar(100)
- Field3 (pay_cardinfo) — varchar(100)
- Field4 (pay_itemname) — varchar(100)
- Field (pay_catname) — varchar(100)
- Field3 (pay_counting) — int
- Field (pay_paydate) — date
- Field2 (pay_approvedate) — date
쪽지보내기 (cat_msg)
- Key (msg_id) — int — 기본 키 — NOT NULL
- Key (u_id) — int — 외래 키 → 유저 정보.Key — NOT NULL
- Field (send_id) — vatchar(50) — NOT NULL
- Field (receive_id) — vatchar(50) — NOT NULL
- Field (content) — vatchar(1000)
- Field (write_date) — datetime
- Field2 (read_yn) — tinyint(1)
활동내역 (support_event)
- Field (se_id) — int — 기본 키 — NOT NULL
- Key (u_id) — int — 외래 키 → 유저 정보.Key — NOT NULL
- Field (event_title) — NOT NULL
- Field (event_text)
- Field (event_writedate)
- Field (event_update)
- Field (event_deletedate)
- Field (event_show)
- Field (event_viewcount)
- Field (event_imageUrl)
- Field (event_imageName)