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)