1

Tables (3)

attandence_table (ㅇ)

  • 유저 id (user_id) — CHAR(8) — Foreign key → user_table.user_id — NOT NULL
  • 강의 넘버링 (lecture_id) — Foreign key → lecture_table.강의 넘버링
  • 출석 여부 (attandence)

lecture_table (강의 테이블)

  • 강의 넘버링 (lecture_id) — Primary key
  • 강의명 (lecture_name)

user_table (유저 테이블)

  • user_id — CHAR(8) — Primary key — NOT NULL
  • user_name — VARCHAR(10) — NOT NULL
  • user_profile_picture — VARCHAR(100)
  • user_phone_number — VARCHAR(15) — NOT NULL
  • user_birth — VARCHAR(10) — NOT NULL
  • user_email — VARCHAR(30) — NOT NULL
  • user_password — VARCHAR(20) — NOT NULL
  • user_warning — BOOLEAN — NOT NULL
  • user_score_ikeeper — TINYINT
  • user_score_field — TINYINT
  • user_score_activity — TINYINT
  • user_score_etc — TINYINT
  • user_score_sum — TINYINT
  • user_attendance — TINYINT — NOT NULL