아

테이블 (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