공통pjt

테이블 (14)

Answer (Untitled11)

  • q_id (Key) — varchar — 외래 키 → Question.question_id — NOT NULL
  • content (Field) — varchar — NOT NULL
  • created_at (Field2) — varchar — NOT NULL

Comment (Untitled9)

  • gc_id (Key) — varchar — 외래 키 → GameCommunity.gc_id
  • email (Key2) — varchar — 외래 키 → User.email — NOT NULL
  • content (Field) — varchar — NOT NULL
  • created_at (Field2) — datetime — NOT NULL
  • updated_at (Field3) — datetime — NOT NULL

Follow (Untitled12)

  • follower (Key) — varchar — 외래 키 → User.email — NOT NULL
  • following (Key2) — varchar — 외래 키 → User.email — NOT NULL

Funding (Untitled3)

  • funding_id (Key) — varchar — 기본 키 — NOT NULL
  • game_id (Key2) — varchar — 외래 키 → Game.game_id — NOT NULL
  • email (Key3) — varchar — 외래 키 → User.email — NOT NULL
  • money (Field) — int
  • funded_at (Field2) — datetime — NOT NULL

Game (Untitled2)

  • game_id (Key) — varchar — 기본 키 — NOT NULL
  • name (Field) — varchar — NOT NULL
  • deadline (Field2) — date — NOT NULL
  • aim (Field4) — int
  • left (Field5) — int
  • is_end (Field6) — boolean
  • email (Key2) — varchar — 외래 키 → User.email — NOT NULL
  • thumbnail (Field3) — varchar — NOT NULL
  • created_at (Field7) — datetime — NOT NULL
  • updated_at (Field8) — datetime — NOT NULL
  • status (Field9) — varchar — NOT NULL

GameCommunity (Untitled8)

  • gc_id (Key) — varchar — 기본 키 — NOT NULL
  • email (Key2) — varchar — 외래 키 → User.email — NOT NULL
  • game_id (Key3) — varchar — 외래 키 → Game.game_id — NOT NULL
  • title (Field) — varchar — NOT NULL
  • content (Field2) — varchar — NOT NULL
  • created_at (Field3) — date — NOT NULL
  • updated_at (Field4) — datetime — NOT NULL

GameDetail (Untitled5)

  • game_id (Key) — varchar — 외래 키 → Game.game_id — NOT NULL
  • content (Field) — varchar
  • d_stage (Field3) — int — NOT NULL

Game_genre (Untitled7)

  • game_genre_id (Key) — varchar — 기본 키 — NOT NULL
  • game_id (Key2) — varchar — 외래 키 → Game.game_id — NOT NULL
  • genre_id (Key3) — varchar — 외래 키 → Genre.genre_id — NOT NULL

Genre (Untitled6)

  • genre_id (Key) — varchar — 기본 키 — NOT NULL
  • name (Field) — varchar — NOT NULL

Like (Untitled13)

  • user (Key) — varchar — 외래 키 → User.email — NOT NULL
  • game_id (Key2) — varchar — 외래 키 → Game.game_id — NOT NULL

Question (Untitled10)

  • question_id (Key) — varchar — 기본 키 — NOT NULL
  • q_email (Key2) — varchar — 외래 키 → User.email — NOT NULL
  • game_id (Key3) — varchar — 외래 키 → Game.game_id — NOT NULL
  • title (Field) — varchar — NOT NULL
  • content (Field2) — varchar — NOT NULL
  • is_resolved (Field3) — boolean — NOT NULL
  • created_at (Field5) — datetime\ — NOT NULL

Reward (Untitled4)

  • reward_id (Key2) — varchar — 기본 키 — NOT NULL
  • game_id (Key) — varchar — 외래 키 → Game.game_id — NOT NULL
  • name (Field) — varchar
  • r_img (Field2) — varchar
  • left (Field3) — int
  • price (Field4) — int
  • content (Field5) — varchar

User (Untitled)

  • email (Key) — varchar — 기본 키 — NOT NULL
  • name (Field) — varchar — NOT NULL
  • password (Field2) — varchar — NOT NULL
  • address (Field3) — varchar
  • account (Field4) — varchar
  • is_developer (Field5) — boolean — NOT NULL
  • phone_number (Field6) — varchar
  • is_admin (Field7) — boolean — NOT NULL

communityLike (Untitled14)

  • email (Key) — varchar — 외래 키 → User.email — NOT NULL
  • gc_id (Key2) — varchar — 외래 키 → GameCommunity.gc_id — NOT NULL