reborn

Tables (10)

GamePlayed (Untitled6)

  • id (pk) — Primary key — NOT NULL
  • gameID (게임 아이디) — Foreign key → games.id — NOT NULL
  • playUserId (play한 유저 id) — Foreign key → users.id — NOT NULL

Posts (Untitled8)

  • id (pk) — Primary key — NOT NULL
  • text (답변)
  • game_id (게임 아이디) — Foreign key → games.id — NOT NULL
  • user_id (유저 아이디) — Foreign key → users.id — NOT NULL
  • quiz_id (퀴즈 아이디) — Foreign key → quiz.id — NOT NULL
  • matchRate (일치율)

character_pending (Untitled7)

  • id (pk) — Primary key — NOT NULL
  • job_id (일 아이디)
  • user_id (유저 아이디) — Foreign key → users.id — NOT NULL
  • status (상태)
  • profile_url (프로필 1장 url)
  • motion_sheet_url (모션 url)

characters (Untitled5)

  • id (pk) — Primary key — NOT NULL
  • motion_sheet_url (모션 시트 url)
  • userId (유저 아이디) — Foreign key → users.id — NOT NULL
  • character_image (캐릭터 이미지)
  • character_detail_url (캐릭터 디테일 url)

games (Untitled2)

  • id (pk) — Primary key — NOT NULL
  • code (게임 코드)
  • userId (유저 아이디) — Foreign key → users.id — NOT NULL
  • game (게임 이름)
  • thumbnail_url (섬네일)
  • background (배경)
  • objectScale (float)
  • background_url (배경 url)

input_image (Untitled10)

  • id (pk) — Primary key — NOT NULL
  • url (input image)
  • agem_id (게임 아이디) — Foreign key → games.id — NOT NULL

input_source (Untitled9)

  • id (pk) — Primary key — NOT NULL
  • text (내용)
  • game_id (게임 아이디) — Foreign key → games.id — NOT NULL

objects (Untitled4)

  • id (pk) — Primary key — NOT NULL
  • object_directory_url (오브젝트 저장된 디렉토리url)
  • gameId (게임아이디) — Foreign key → games.id — NOT NULL
  • name (이름)
  • x_pos (x좌표)
  • y_pos (y 좌표)
  • height (길이)
  • introStory (인트로 이야기)
  • outroStory (아웃트로 이야기)

quiz (Untitled3)

  • id (pk) — Primary key — NOT NULL
  • story (이야기)
  • question (질문)
  • answer (정답)
  • gameId (게임 아이디) — Foreign key → games.id — NOT NULL
  • objectId (오브젝트 아이디) — Foreign key → objects.id — NOT NULL

users (Untitled)

  • id (pk) — Primary key — NOT NULL
  • nickcname (닉네임)
  • password (비밀번호)