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