code arena
Tables (8)
Board
- id — BIGINT
- member_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- type — VARCHAR(50) — NOT NULL
- views — INT — NOT NULL
- like — INT — NOT NULL
Code
- id — BIGINT
- room_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- language — VARCHAR(50) — NOT NULL
- member_id — BIGINT — NOT NULL
- problem — TEXT
Comment
- id — BIGINT
- member_id — BIGINT — NOT NULL
- board_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- like — INT — NOT NULL
FeedBack
- id — BIGINT
- member_id — BIGINT — NOT NULL
- code_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
Group
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
GroupMember
- member_id — BIGINT — NOT NULL
- group_id — BIGINT — NOT NULL
Member
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- birth — DATE — NOT NULL
- role — VARCHAR(50) — NOT NULL
- image — VARCHAR(255)
Room
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- is_group — BOOLEAN — NOT NULL
- status — ENUM('private', 'public') — NOT NULL
- group_id — BIGINT
- password — VARCHAR(255)