catdog
Tables (15)
board
- id — INT(11) — Primary key — NOT NULL
- writer — VARCHAR(16) — NOT NULL
- content — VARCHAR(45) — NOT NULL
cart
- cart_no — INT(11) — Primary key — NOT NULL
- user_id — VARCHAR(45) — Foreign key → user.user_id
- product_no — INT(11) — Foreign key → product.product_no
- cart_quantity — INT(11)
- INDEX — `cart_user_id_idx`
- INDEX — `cart_product_no_idx`
category1
- category1_no — INT(11) — Primary key — NOT NULL
- category1_type — VARCHAR(45)
category2
- category2_no — INT(11) — Primary key — NOT NULL
- category2_type — VARCHAR(45)
community
- community_no — INT(11) — Primary key — NOT NULL
- user_id — VARCHAR(45) — Foreign key → user.user_id — NOT NULL
- category_no — INT(11) — Foreign key → category1.category1_no — NOT NULL
- community_content — VARCHAR(2000) — NOT NULL
- community_regdate — DATETIME — NOT NULL
- community_editdate — DATETIME
- INDEX — `user_id_idx`
- INDEX — `category_no_idx`
heart
- heart_no — INT(11) — Primary key — NOT NULL
- community_no — INT(11) — Foreign key → community.community_no — NOT NULL
- user_id — VARCHAR(45) — Foreign key → user.user_id — NOT NULL
- heart_boolean — TINYINT(1) — NOT NULL
- INDEX — `like_community_no_idx`
- INDEX — `like_user_id_idx`
hospital
- hospital_id — INT(11) — Primary key — NOT NULL
- address_name — VARCHAR(45)
- phone — VARCHAR(45)
- place_name — VARCHAR(45)
- place_url — VARCHAR(45)
- road_address_name — VARCHAR(45)
- longitude — DOUBLE
- latitude — DOUBLE
matching
- matching_no — INT(11) — Primary key — NOT NULL
- user_id — VARCHAR(45) — Foreign key → user.user_id — NOT NULL
- matching_user_id — VARCHAR(45) — NOT NULL
- matching_request — INT(11) — NOT NULL
- matching_response — INT(11) — NOT NULL
- matching_result — TINYINT(1)
- INDEX — `matching_rq_user_id_idx`
media
- media_no — INT(11) — Primary key — NOT NULL
- community_no — INT(11) — Foreign key → community.community_no
- media_type — INT(11)
- media_path — VARCHAR(300)
- product_no — INT(11) — Foreign key → product.product_no
- INDEX — `media_community_no_idx`
- INDEX — `media_product_no_idx`
order
- order_no — INT(11) — Primary key — NOT NULL
- user_id — VARCHAR(45) — Foreign key → user.user_id — NOT NULL
- order_price — INT(11) — NOT NULL
- order_date — DATETIME — NOT NULL
- INDEX — `order_user_id_idx`
pet
- pet_no — INT(11) — Primary key — NOT NULL
- user_id — VARCHAR(45) — Foreign key → user.user_id — NOT NULL
- category1_no — INT(11) — Foreign key → category1.category1_no
- category2_no — INT(11) — Foreign key → category2.category2_no
- pet_name — VARCHAR(45)
- pet_age — INT(11)
- pet_animalnum — BIGINT(20)
- pet_gender — INT(11)
- INDEX — `pet_user_id_idx`
- INDEX — `pet_category1_no_idx`
- INDEX — `pet_category2_no_idx`
product
- product_no — INT(11) — Primary key — NOT NULL
- user_id — VARCHAR(45) — Foreign key → user.user_id — NOT NULL
- category1_no — INT(11) — Foreign key → category1.category1_no
- product_name — VARCHAR(45)
- product_stock — INT(11)
- product_content — VARCHAR(500)
- product_price — INT(11)
- product_regdate — DATETIME
- product_soldQuantity — INT(11)
- INDEX — `user_id_idx`
- INDEX — `product_category1_no_idx`
reply
- reply_no — INT(11) — Primary key — NOT NULL
- community_no — INT(11) — Foreign key → community.community_no — NOT NULL
- user_id — VARCHAR(45) — Foreign key → user.user_id — NOT NULL
- reply_content — VARCHAR(500) — NOT NULL
- reply_regdate — DATETIME — NOT NULL
- INDEX — `reply_community_no_idx`
- INDEX — `reply_user_id_idx`
review
- review_no — INT(11) — Primary key — NOT NULL
- user_id — VARCHAR(45) — Foreign key → user.user_id — NOT NULL
- product_no — INT(11) — Foreign key → product.product_no — NOT NULL
- review_regdate — DATETIME
- review_score — INT(11)
- review_content — VARCHAR(100) — NOT NULL
- INDEX — `user_id_idx`
- INDEX — `product_no_idx`
user
- user_id — VARCHAR(45) — Primary key — NOT NULL
- user_pw — VARCHAR(100) — NOT NULL
- user_name — VARCHAR(45) — NOT NULL
- user_phoneNumber — VARCHAR(45)
- user_regdate — DATETIME
- user_image — VARCHAR(100)
- user_matchinguse — TINYINT(1)