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