취코모

테이블 (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