ggggg
Tables (7)
answer
- ans_no — int — Primary key — NOT NULL
- ask_no — int — Foreign key → ask.ask_no — NOT NULL
- ans_content — varchar(500) — NOT NULL
- ans_writer — varchar(20) — 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_title — varchar(200) — NOT NULL
- ask_content — varchar(500) — NOT NULL
- ask_writer — varchar(20) — NOT NULL
- ask_date — timestamp
- ask_img1 — varchar(500)
- ask_img2 — varchar(500)
- ask_img3 — varchar(500)
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) — Foreign key → bill.bill_no — NOT NULL
- bill_dx — varchar(100) — NOT NULL
- bill_fee — int — NOT NULL
faq
- faq_no — int — Primary key — NOT NULL
- faq_category — varchar(100) — NOT NULL
- faq_title — varchar(200) — NOT NULL
- faq_content — varchar(500) — NOT NULL
- faq_writer — varchar(20) — NOT NULL
- faq_date — timestamp
- faq_img1 — varchar(500)
- faq_img2 — varchar(500)
- faq_img3 — 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)
star
- star_no — int — Primary key — NOT NULL
- service_id — int — Foreign key → petservice.service_id — 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)