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