코틀린

테이블 (9)

ai_queries

  • id — BIGSERIAL
  • cat_id — BIGINT
  • query_text — TEXT — NOT NULL
  • response_text — TEXT
  • created_at — TIMESTAMP

cats

  • id — BIGSERIAL
  • name — VARCHAR(50) — NOT NULL
  • age — INT — NOT NULL
  • breed — VARCHAR(50)
  • gender — VARCHAR(10)
  • owner_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP

community_comments

  • id — BIGSERIAL
  • post_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

community_likes

  • id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • post_id — BIGINT
  • comment_id — BIGINT
  • created_at — TIMESTAMP

community_posts

  • id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • image_url — TEXT
  • created_at — TIMESTAMP

health_records

  • id — BIGSERIAL
  • cat_id — BIGINT — NOT NULL
  • record_type — VARCHAR(50) — NOT NULL
  • description — TEXT
  • date — DATE — NOT NULL

images

  • id — BIGSERIAL
  • cat_id — BIGINT
  • image_url — TEXT — NOT NULL
  • uploaded_at — TIMESTAMP

meal_records

  • id — BIGSERIAL
  • cat_id — BIGINT — NOT NULL
  • food_name — VARCHAR(100) — NOT NULL
  • is_favorite — BOOLEAN
  • has_allergy — BOOLEAN
  • meal_time — TIMESTAMP

users

  • id — BIGSERIAL
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password_hash — TEXT — NOT NULL
  • created_at — TIMESTAMP