tt
Tables (10)
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 — NOT NULL
- content — TEXT — NOT NULL
- parent_comment_id — INT — Foreign key → Comment.comment_id
- created_at — TIMESTAMP — NOT NULL
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)
Log
- log_id — BIGINT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.user_id
- log_code — VARCHAR(50)
- time — TIMESTAMP — NOT NULL
- content — TEXT
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) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- 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)
- created_at — TIMESTAMP — NOT NULL
VectorSyncQueue
- queue_id — BIGINT — Primary key — NOT NULL
- pod_id — INT — NOT NULL
- action_type — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL