prac_starrynightGame

Tables (7)

Member (회원)

  • id (식별자) — BIGINT — Primary key — NOT NULL
  • date (가입일자) — DATE
  • starcoin_count (스타코인개수) — BIGINT

MemberQuest (회원의스토리퀘스트상태)

  • id (식별자) — BIGINT — Primary key — NOT NULL
  • quest_id (퀘스트 식별자) — BIGINT — Foreign key → Quest.id — NOT NULL
  • memberstory_id (멤버스토리 식별자) — BIGINT — Foreign key → MemberStory.id — NOT NULL
  • state (진행 상황) — STRING
  • proceeding_count (현재 진행 개수) — BIGINT

MemberStarCoin (회원스타코인상태)

  • id (식별자) — BIGINT — Primary key — NOT NULL
  • starcoin_id (스타코인 식별자) — BIGINT — Foreign key → StarCoin.id — NOT NULL
  • member_id (멤버 식별자) — BIGINT — Foreign key → Member.id — NOT NULL
  • isTaken (획득여부) — VARCHAR(1)

MemberStory (회원의스토리진행상태)

  • id (식별자) — BIGINT — Primary key — NOT NULL
  • member_id (멤버 식별자) — BIGINT — Foreign key → Member.id — NOT NULL
  • story_id (스토리 식별자) — BIGINT — Foreign key → Story.id — NOT NULL
  • current_stage (현재 진행번호) — BIGINT
  • isClear (스토리 완료했었는지) — VARCHAR(1)

Quest (스토리 퀘스트)

  • id (식별자) — BIGINT — Primary key — NOT NULL
  • story_id (스토리 식별자) — BIGINT — Foreign key → Story.id — NOT NULL
  • title (퀘스트 제목) — VARCHAR
  • total_count (완료 조건 개수) — BIGINT

StarCoin (스타코인)

  • id (식별자) — BIGINT — Primary key — NOT NULL
  • story_id (스토리 식별자) — BIGINT — Foreign key → Story.id — NOT NULL
  • loc_x (x좌표)
  • loc_y (y좌표)
  • loc_z (z좌표)
  • map (맵이름) — STRING

Story (스토리)

  • id (식별자) — BIGINT — Primary key — NOT NULL
  • title (스토리제목) — VARCHAR