최종 프로젝트

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