취코모
테이블 (11)
chat_messages
- id — BIGINT — 기본 키
- sender_id — BIGINT
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- chat_id — BIGINT — 외래 키 → chats.id
chat_participants
- id — BIGINT — 기본 키
- user_id — BIGINT — 외래 키 → users.id
- chat_id — BIGINT — 외래 키 → chats.id
chats
- id — BIGINT — 기본 키
- name — VARCHAR(255)
- is_group — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
community (communities)
- id — BIGINT — 기본 키
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- level — ENUM('Major', 'Minor', 'New') — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
job_posts
- id — BIGINT — 기본 키
- company_name — VARCHAR(255) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- location — VARCHAR(255)
- salary — VARCHAR(255)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
job_tags
- id — BIGINT — 기본 키
- tag — VARCHAR(255) — NOT NULL
- job_post_id — BIGINT — 외래 키 → job_posts.id
notifications
- id — BIGINT — 기본 키
- type — VARCHAR(50) — NOT NULL
- message — TEXT — NOT NULL
- is_read — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- user_id — BIGINT — 외래 키 → users.id
post_likes
- id — BIGINT — 기본 키
- type — VARCHAR(10) — NOT NULL
- user_id — BIGINT — 외래 키 → users.id
- post_id — BIGINT — 외래 키 → posts.id
post_tags
- id — BIGINT — 기본 키
- tag — VARCHAR(255) — NOT NULL
- post_id — BIGINT — 외래 키 → posts.id
posts
- id — BIGINT — 기본 키
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
- community_id — BIGINT — 외래 키 → community.id
users
- id — BIGINT — 기본 키
- username — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- oauth_provider — VARCHAR(50)
- oauth_id — VARCHAR(255)
- login_type — ENUM('BASIC', 'OAUTH') — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL