최종 프로젝트
테이블 (15)
Admin
- admin_id — BIGINT — 기본 키 — NOT NULL
- login_id — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- user_status — ENUM('ADMIN', 'USER') — NOT NULL
Categories
- category_id — BIGINT — 기본 키 — NOT NULL
- game_id (game_id2) — BIGINT — 외래 키 → Game.game_id — NOT NULL
- category_name — VARCHAR(255) — NOT NULL
Chat (Chats)
- chat_id — BIGINT — 기본 키 — NOT NULL
- user_id (user_id2) — BIGINT — 외래 키 → User.user_id — NOT NULL
- chat_room_id (chat_room_id2) — BIGINT — 외래 키 → ChatRoom.chat_room_id — NOT NULL
- content — VARCHAR(255)
- username — VARCHAR(255)
- create_time — DATETIME
ChatRoom
- chat_room_id — BIGINT — 기본 키 — NOT NULL
- user_id (user_id3) — BIGINT — 외래 키 → User.user_id — NOT NULL
- name — VARCHAR(255)
- is_security — BOOLEAN
- password — VARCHAR(255)
Comment
- comment_id — BIGINT — 기본 키 — NOT NULL
- post_id (post_id2) — BIGINT — 외래 키 → Posts.post_id — NOT NULL
- user_id (user_id2) — BIGINT — 외래 키 → User.user_id — NOT NULL
- text — TEXT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
Exchange
- exchange_id — BIGINT — 기본 키 — NOT NULL
- game_id (game_id2) — BIGINT — 외래 키 → Game.game_id — NOT NULL
- user_id (user_id2) — BIGINT — 외래 키 → User.user_id — NOT NULL
- title — VARCHAR(255)
- price — INT
- contact — VARCHAR(20)
- description — TEXT
- quantity — INT
- created_at — DATETIME
- updated_at — DATETIME
- trade_type — ENUM('BUY', 'SELL') — NOT NULL
- is_completed — BOOLEAN
Game
- game_id — BIGINT — 기본 키 — NOT NULL
- admin_id (admin_id2) — BIGINT — 외래 키 → Admin.admin_id — NOT NULL
- game_name — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
GameProposal
- proposal_id — BIGINT — 기본 키 — NOT NULL
- user_id (user_id2) — BIGINT — 외래 키 → User.user_id — NOT NULL
- admin_id (admin_id2) — BIGINT — 외래 키 → Admin.admin_id — NOT NULL
- game_title — VARCHAR(255)
- description — TEXT
- status — ENUM('WAITING', 'CANCELED', 'APPROVED', 'REJECTED')
- created_at — DATETIME
- updated_at — DATETIME
GlobalChats
- global_chat_id — BIGINT — 기본 키 — NOT NULL
- user_id (user_id2) — BIGINT — 외래 키 → User.user_id — NOT NULL
- content — VARCHAR(255)
- create_time — DATETIME
MyExchange
- exchange_key — VARCHAR(255) — 기본 키 — NOT NULL
- exchange_id (exchange_id2) — BIGINT — 외래 키 → Exchange.exchange_id — NOT NULL
- user_id (user_id2) — BIGINT — 외래 키 → User.user_id — NOT NULL
- contact — VARCHAR(15)
- status_type — ENUM('BEFORE', 'PROGRESS', 'COMPLETED', 'CANCELED')
Notification
- notification_id — BIGINT — 기본 키 — NOT NULL
- user_id (user_id2) — BIGINT — 외래 키 → User.user_id — NOT NULL
- chat_room_id (chat_room_id2) — BIGINT — 외래 키 → ChatRoom.chat_room_id — NOT NULL
- chat_id (chat_id2) — BIGINT — 외래 키 → Chat.chat_id — NOT NULL
- created_time — DATETIME
Posts
- post_id — BIGINT — 기본 키 — NOT NULL
- user_id (user_id2) — BIGINT — 외래 키 → User.user_id — NOT NULL
- game_id (game_id2) — BIGINT — 외래 키 → Game.game_id — NOT NULL
- category_id (category_id2) — BIGINT — 외래 키 → Categories.category_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- view_count — INT — NOT NULL
- status — ENUM('DRAFT', 'PUBLISHED', 'RECOMMENDED') — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
Recommandation
- recommandation_id — BIGINT — 기본 키 — NOT NULL
- post_id (post_id2) — BIGINT — 외래 키 → Posts.post_id — NOT NULL
- user_id (user_id2) — BIGINT — 외래 키 → User.user_id — NOT NULL
- created_at — DATETIME
Review
- review_id — BIGINT — 기본 키 — NOT NULL
- exchange_id (exchange_id2) — BIGINT — 외래 키 → Exchange.exchange_id — NOT NULL
- user_id (user_id2) — BIGINT — 외래 키 → User.user_id — NOT NULL
- rating — INT — NOT NULL
- review_text — TEXT
User
- user_id — BIGINT — 기본 키 — NOT NULL
- login_id — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- user_status — ENUM('ADMIN', 'USER') — NOT NULL
- kakao_id — BIGINT
- is_deleted — BOOLEAN — NOT NULL