JONGSEOL
Tables (6)
Friendship (Untitled4)
- memberID1 (ID) — VARCHAR — Foreign key → Member.memberID — NOT NULL
- memberID2 (ID2) — VARCHAR — Foreign key → Member.memberID — NOT NULL
- status (Field) — ENUM
GameRecord (Untitled2)
- gameRecordID (Key) — NUMBER — Primary key — NOT NULL
- score_earned (Field) — NUMBER
- played_at (Field2) — DATEg
- game_type (Field3) — enum
- picture_url (Field4) — varchar
- answer (Field5) — varchar
- ai_prediction (Field6) — varchar
- similarity (Field7) — number
Member
- memberID (ID) — VARCHAR — Primary key — NOT NULL
- username — VARCHAR
- password (Field2) — VARCHAR
- email (Field) — VARCHAR
- role (Field3) — ENUM
- created_at (Field4) — DATE
- last_login (Field5) — DATE\
- score_game1 (Field6) — number
- score_game2 (Field7) — number
- Field8
MemberGameRecord (Untitled3)
- memberID (ID) — VARCHAR — Foreign key → Member.memberID — NOT NULL
- gameRecordID (Key) — NUMBER — Foreign key → GameRecord.gameRecordID — NOT NULL
Notice (Untitled5)
- noticeID (Key) — NUMBER — Primary key — NOT NULL
- created_at (Field2) — DATE
- content (Field3) — VARCHAR
- title (Field4) — VARCHAR
- writerID (ID) — VARCHAR — Foreign key → Member.memberID — NOT NULL
Report (CopyOfUntitled4)
- report_ID (Key) — Primary key — NOT NULL
- memberID1 (ID) — VARCHAR — Foreign key → Member.memberID — NOT NULL
- memberID2 (ID2) — VARCHAR — Foreign key → Member.memberID — NOT NULL
- report_Type (Field) — VARCHAR
- report_status (Field2) — ENUM
- report_detail (Field3) — VARHCAR
- created_at (Field4) — DATE
- Field5