PC통신

테이블 (5)

Channel (Untitled3)

  • id (channel_id) — BIG_INT — 기본 키 — NOT NULL — AI
  • name (channel_name) — VARCHAR — NOT NULL
  • password — VARCHAR

ChannelUser (ㅊ)

  • id (channel_user_id) — BIG_INT — 기본 키 — NOT NULL — AI
  • id (member_id) — BIGINT — 외래 키 → user.id — NOT NULL — AUTO_IN
  • id (channel_id2) — BIG_INT — 외래 키 → Channel.id — NOT NULL — AI

Message (Untitled2)

  • id (message_id) — BIG_INT — 기본 키 — NOT NULL — AI
  • id (channel_id) — BIG_INT — 외래 키 → Channel.id — NOT NULL — AI
  • content — VARCHAR(255) — NOT NULL
  • channel (chennel_id) — BIGINT — NOT NULL
  • create_date — DATETIME(6) — NOT NULL
  • sender (member_id) — BIGINT — 외래 키 → user.id — NOT NULL — AUTO_IN

post (게시판)

  • Key (post_id) — BIGINT — 기본 키 — NOT NULL — AI
  • title
  • writer — BIGINT — NOT NULL
  • content (Field) — VARCHAR(255) — NOT NULL
  • create_date (Field2) — DATETIME(6) — NOT NULL
  • update_date (Field3)
  • type — VARCHAR(10) — NOT NULL — ENUM타입
  • id (member_id) — BIG_INT — 외래 키 → user.id — NOT NULL — AUTO_IN

user (회원)

  • id (member_id) — BIG_INT — 기본 키 — NOT NULL — AUTO_IN
  • password (member_password)
  • Field