test

Tables (6)

CATEGORIES

  • category_id — BIGINT
  • name — VARCHAR(50) — NOT NULL

COMMENTS

  • comment_id — BIGINT
  • user_id — BIGINT — Foreign key → USERS.user_id
  • post_id2 — BIGINT — Foreign key → POSTS.post_id
  • content — TEXT — NOT NULL
  • author_id — BIGINT
  • post_id — BIGINT — NOT NULL
  • parent_id — BIGINT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

GROUPS

  • group_id — BIGINT
  • user_id — BIGINT — Foreign key → USERS.user_id
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • cover_image_url — VARCHAR(255)
  • region — VARCHAR(100)
  • max_members — INT — NOT NULL
  • current_members — INT — NOT NULL
  • is_public — BOOLEAN — NOT NULL
  • owner_id — BIGINT — NOT NULL
  • category_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP
  • category_id2 — BIGINT

MEMBERSHIPS

  • membership_id — BIGINT
  • user_id2 — BIGINT — Foreign key → USERS.user_id
  • role — VARCHAR(20) — NOT NULL
  • joined_at — TIMESTAMP
  • group_id2 — BIGINT

POSTS

  • post_id — BIGINT
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • post_type — VARCHAR(20) — NOT NULL
  • image_url — VARCHAR(255)
  • author_id — BIGINT
  • group_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • group_id2 — BIGINT
  • user_id — BIGINT

USERS

  • user_id — BIGINT
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image_url — VARCHAR(255)
  • introduction — VARCHAR(255)
  • created_at — TIMESTAMP