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