withPuppy
Tables (17)
answer
- ans_no — int — Primary key — NOT NULL
- ask_no — int — NOT NULL
- ans_writer — varchar(20) — NOT NULL
- ans_content — varchar(500) — NOT NULL
- ans_date — timestamp
- ans_img1 — varchar(500)
- ans_img2 — varchar(500)
- ans_img3 — varchar(500)
- ans_like — int
ask
- ask_no — int — Primary key — NOT NULL
- ask_writer — varchar(20) — NOT NULL
- ask_title — varchar(200) — NOT NULL
- ask_content — varchar(500) — NOT NULL
- ask_date — timestamp
- ask_img1 — varchar(500)
- ask_img2 — varchar(500)
- ask_img3 — varchar(500)
big_category
- categoryNum — int — Primary key — NOT NULL
- categoryName — varchar(20) — NOT NULL
bill
- bill_no — varchar(100) — Primary key — NOT NULL
- bill_brn — varchar(20) — NOT NULL
- bill_name — varchar(100) — NOT NULL
- bill_addr — varchar(100) — NOT NULL
- bill_totalfee — int — NOT NULL
bill_detail
- bill_no — varchar(100) — NOT NULL
- bill_dx — varchar(100) — NOT NULL
- bill_fee — int — NOT NULL
cart
- cart_id — int — Primary key — NOT NULL
- product_id — int — NOT NULL
- product_cnt — int — NOT NULL
- user_id2 — varchar(20) — NOT NULL
category
- categoryNum — int — Primary key — NOT NULL
- categoryDetail — varchar(20) — NOT NULL
- bigCategoryNum — int — NOT NULL
communities
- commu_no — int — Primary key — NOT NULL
- commu_id — varchar(20) — NOT NULL
- commu_title — varchar(200) — NOT NULL
- commu_content — varchar(1000) — NOT NULL
- commu_img — varchar(500)
- commu_img2 — varchar(500)
- commu_img3 — varchar(500)
- category1 — varchar(200) — NOT NULL
- commu_view — int
- commu_date — timestamp
faq
- faq_no — int — Primary key — NOT NULL
- user_id — varchar(20) — NOT NULL
- faq_category — varchar(100) — NOT NULL
- faq_title — varchar(200) — NOT NULL
- faq_content — varchar(500) — NOT NULL
- faq_date — timestamp
- faq_img1 — varchar(500)
- faq_img2 — varchar(500)
- faq_img3 — varchar(500)
order1
- order_id — int — Primary key — NOT NULL
- user_id — varchar(20) — NOT NULL
- order_date — datetime — NOT NULL
- receiver_name — varchar(20) — NOT NULL
- receiver_phone — varchar(20) — NOT NULL
- receiver_id — varchar(100) — NOT NULL
- addr1 — varchar(100) — NOT NULL
- addr2 — varchar(100) — NOT NULL
- addr3 — varchar(100) — NOT NULL
- total_price — int — NOT NULL
order_detail
- order_id — int — NOT NULL
- product_id — int — NOT NULL
- ordered_cnt — int — NOT NULL
- order_status — varchar(10) — NOT NULL
- refundCheck_YN — varchar(1) — NOT NULL
pet
- pet_no — int — Primary key — NOT NULL
- pet_owner — varchar(20) — NOT NULL
- pet_name — varchar(20) — NOT NULL
- pet_birth — date
- pet_kind — varchar(50)
- pet_weight — varchar(20)
- pet_img — varchar(500)
petservice
- service_id — int — Primary key — NOT NULL
- service_name — varchar(100)
- latitude — double
- longitude — double
- zipcode — varchar(100)
- road_address — varchar(100)
- address — varchar(100)
- tel — varchar(100)
- homepage — varchar(500)
- dayoff — varchar(100)
- petsize — varchar(100)
- operating — varchar(128)
- parking — varchar(50)
product
- product_id — int — Primary key — NOT NULL
- product_name — varchar(100) — NOT NULL
- product_price — int — NOT NULL
- category1 — int — NOT NULL
- category2 — int — NOT NULL
- detail — int — NOT NULL
- product_img — varchar(500) — NOT NULL
- product_cnt — int — NOT NULL
- soldout_YN — varchar(1)
- status — varchar(20)
- categoryDetail — varchar(20)
reply
- reply_no — int — Primary key — NOT NULL
- reply_id — varchar(20)
- reply_content — varchar(300)
- commu_no — int
- reply_date — timestamp
star
- star_no — int — Primary key — NOT NULL
- service_id — int — NOT NULL
- id — varchar(20) — NOT NULL
- date — timestamp — NOT NULL
- content — varchar(500) — NOT NULL
- kind — int — NOT NULL
- explain — int — NOT NULL
- treat — int — NOT NULL
- facilities — int — NOT NULL
- price — int — NOT NULL
- img1 — varchar(500)
- img2 — varchar(500)
- ocr — varchar(500)
user
- user_id — varchar(20) — Primary key — NOT NULL
- user_pw — varchar(20) — NOT NULL
- user_email — varchar(100) — NOT NULL
- user_tel — varchar(20) — NOT NULL
- user_addr1 — varchar(100) — NOT NULL
- user_nickname — varchar(20) — NOT NULL
- user_img — varchar(500)
- user_level — varchar(20) — NOT NULL
- user_interest — varchar(20)
- user_state — varchar(20)
- user_joindate — timestamp — NOT NULL
- user_visit — int
- user_name — varchar(100) — NOT NULL
- user_addr2 — varchar(100) — NOT NULL
- user_addr3 — varchar(100) — NOT NULL
- user_addr4 — varchar(100) — NOT NULL
- user_addr5 — varchar(100)
- user_recentvisit — date
- user_commu — int
- user_reply — int