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