ddsffd
Tables (9)
category
- category_id — INT — Primary key — NOT NULL
- category_name — VARCHAR(100) — NOT NULL
- parent_category_id — INT — Foreign key → category.category_id
categorylink
- category_link_id — INT — Primary key — NOT NULL
- pod_id — INT — Foreign key → pod.pod_id — NOT NULL
- category_id — INT — Foreign key → category.category_id — NOT NULL
chat
- chat_id — BIGINT — Primary key — NOT NULL
- pod_id — INT — Foreign key → pod.pod_id — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- content — TEXT
- time — TIMESTAMP — NOT NULL
comment
- comment_id — INT — Primary key — NOT NULL
- pod_id — INT — Foreign key → pod.pod_id — NOT NULL
- user_id — INT — Foreign key → user.user_id
- content — TEXT — NOT NULL
- parent_comment_id — INT — Foreign key → comment.comment_id
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
kakaoapi
- k_id — BIGINT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- access_token — VARCHAR(255)
- refresh_token — VARCHAR(255)
- user_name — VARCHAR(100)
- profile_picture — VARCHAR(255)
pod
- pod_id — INT — Primary key — NOT NULL
- host_user_id — INT — Foreign key → user.user_id — NOT NULL
- event_time — DATETIME — NOT NULL
- place — VARCHAR(255)
- place_detail — VARCHAR(255) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- min_peoples — INT — NOT NULL
- max_peoples — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
pod_member
- pod_member_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- pod_id — INT — Foreign key → pod.pod_id — NOT NULL
- amount — INT
- place_start — VARCHAR(255)
- place_end — VARCHAR(255)
- joined_at — TIMESTAMP — NOT NULL
user
- user_id — INT — Primary key — NOT NULL
- username — VARCHAR(100) — NOT NULL
- phonenumber — VARCHAR(20)
- is_admin — BOOLEAN — NOT NULL
- profile_picture_enabled — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
vectorsyncqueue
- queue_id — BIGINT — Primary key — NOT NULL
- pod_id — INT — NOT NULL
- action_type — ENUM('upsert', 'delete') — NOT NULL
- status — ENUM('pending', 'processing', 'failed') — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- retry_count — INT — NOT NULL