12게임 병합 erd

테이블 (7)

GAMEDATA (Untitled3)

  • Key — 기본 키 — NOT NULL
  • S_ID — INTEGER — 외래 키 → STUDENT.S_ID — NOT NULL
  • G_DATE (Field)
  • G_VALUE (Field2) — STRING

GAMEDATAS_ID

  • Key — 기본 키 — NOT NULL
  • S_ID — INTEGER — 외래 키 → STUDENT.S_ID — NOT NULL
  • G_DATE — DATE
  • G_NAME_0 — TEXT
  • G_NAME_1 — TEXT
  • G_NAME_2 — TEXT
  • G_NAME_3 — TEXT
  • G_NAME_4 — TEXT
  • G_NAME_5 — TEXT
  • G_NAME_6 — TEXT
  • G_NAME_7 — TEXT
  • G_NAME_8 — TEXT
  • G_NAME_9 — TEXT
  • G_NAME_10 — TEXT
  • G_NAME_11 — TEXT
  • G_NAME_12 — TEXT
  • G_NAME_13 — TEXT
  • G_NAME_14 — TEXT
  • G_NAME_15 — TEXT
  • G_NAME_16 — TEXT

STUDENT

  • S_ID — INTEGER — 기본 키 — NOT NULL
  • S_NAME (Field)
  • S_BIRTH (Field2)
  • S_PARENT (Field3)
  • S_PHONE (Field4)
  • S_ADDRESS (Field5)
  • S_TYPE (Field6)
  • S_DEFECT (Field7)
  • S_SPECIAL (Field8)
  • T_ID — INTEGER — 외래 키 → TEACHER.T_ID — NOT NULL

TEACHER

  • T_ID — INTEGER — 기본 키 — NOT NULL
  • T_NAME (Field) — TEXT
  • T_BIRTH (Field2) — TEXT
  • T_ATTACHED (Field3) — TEXT
  • T_PHONE (Field4) — TEXT
  • T_ADDRESS (Field5) — TEXT
  • T_TYPE (Field6) — TEXT
  • T_SPECIAL (Field7) — TEXT

다이빙게임데이터 (DIVING_GAMEDATA)

  • id (Key) — 기본 키 — NOT NULL
  • Date — TEXT — NOT NULL
  • TimeLevel (Field2) — INT — NOT NULL
  • LinePos (Field) — TEXT — NOT NULL
  • MaxOut (Field3) — INT — NOT NULL
  • MaxIn (Field4) — INT — NOT NULL
  • MaxOutRowData (Field5) — INT — NOT NULL
  • MaxInRowData (Field6) — INT — NOT NULL

유저 (Untitled)

  • 인덱스 (Key) — 기본 키 — NOT NULL
  • 아이디 (Field)
  • 비밀번호 (Field2)

케톤 (Untitled2)

  • 인덱스 (Key) — 외래 키 → 유저.인덱스 — NOT NULL
  • 유저아이디 (Field)
  • 키 (Field3)
  • 몸무게 (Field4)
  • 성별 (Field5)
  • 나이 (Field6)