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