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