아
테이블 (15)
ai_queries
- query_id — BIGINT
- user_id — BIGINT
- question — TEXT — NOT NULL
- response — TEXT
- created_at — DATETIME
cart
- cart_id — BIGINT
- user_id — BIGINT
- product_id — BIGINT
- quantity — INT
comments
- comment_id — BIGINT
- post_id — BIGINT
- user_id — BIGINT
- content — TEXT — NOT NULL
- created_at — DATETIME
custom_goods
- custom_id — BIGINT
- user_id — BIGINT
- design_url — VARCHAR(255)
- item_type — VARCHAR(100)
- quantity — INT
- created_at — DATETIME
likes
- like_id — BIGINT
- post_id — BIGINT
- user_id — BIGINT
- created_at — DATETIME
order_items
- order_item_id — BIGINT
- order_id — BIGINT
- product_id — BIGINT
- quantity — INT
- price — DECIMAL(10,2)
orders
- order_id — BIGINT
- user_id — BIGINT
- total_price — DECIMAL(10,2)
- payment_method — ENUM('kakao', 'naver', 'card')
- status — ENUM('paid', 'shipped', 'delivered', 'canceled')
- created_at — DATETIME
pets
- pet_id — BIGINT
- user_id — BIGINT
- name — VARCHAR(100) — NOT NULL
- species — VARCHAR(50)
- breed — VARCHAR(100)
- age — INT
- gender — ENUM('M', 'F')
- is_neutered — BOOLEAN
- photo — VARCHAR(255)
places
- place_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- type — ENUM('hospital', 'cafe', 'hotel', 'salon', 'shelter', 'aquarium') — NOT NULL
- address — TEXT
- latitude — DOUBLE
- longitude — DOUBLE
- phone — VARCHAR(20)
- website — VARCHAR(255)
posts
- post_id — BIGINT
- user_id — BIGINT
- category — ENUM('gallery', 'question', 'chat', 'lost', 'ad', 'review', 'faq', 'training_tip') — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- image_url — VARCHAR(255)
- created_at — DATETIME
- is_answered — BOOLEAN
products
- product_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- price — DECIMAL(10,2)
- category — VARCHAR(100)
- image_url — VARCHAR(255)
- stock — INT
- created_at — DATETIME
reports
- report_id — BIGINT
- reporter_id — BIGINT
- reported_user_id — BIGINT
- post_id — BIGINT
- reason — TEXT
- created_at — DATETIME
reservations
- reservation_id — BIGINT
- user_id — BIGINT
- place_id — BIGINT
- service_type — ENUM('hospital', 'training', 'care')
- date — DATE
- time_slot — VARCHAR(20)
- status — ENUM('pending', 'confirmed', 'canceled')
reviews
- review_id — BIGINT
- place_id — BIGINT
- user_id — BIGINT
- content — TEXT
- rating — INT
- created_at — DATETIME
users
- user_id — BIGINT
- email — VARCHAR(255)
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(100)
- phone — VARCHAR(20)
- profile_img — VARCHAR(255)
- role — ENUM('user', 'vet', 'trainer', 'admin', 'advertiser') — NOT NULL
- oauth_provider — ENUM('kakao', 'naver', 'google')
- location — VARCHAR(255)
- bio — TEXT
- created_at — DATETIME