pirocheck_v2
Tables (6)
Assignment (과제)
- id (Key) — bigint — Primary key — NOT NULL
- assignment_name (Field) — char(225)
- order_number (Field2) — bigint
- section (Field3) — bigint
- submitted (Field4) — char(100)
- week (Field5) — bigint
- id (Key2) — bigint — Foreign key → users.id — NOT NULL
AssignmentSubmission (Untitled)
Attendance (출석)
- id (Key) — bigint — Primary key — NOT NULL
- date (Field) — date
- order_number (Field2) — bigint
- status (Field3) — boolean
- id (Key2) — bigint — Foreign key → users.id — NOT NULL
Attendance_code (출석코드)
- id (Key) — bifint — Primary key — NOT NULL
- code (Field) — char(255)
- date (Field2) — date
- is_expired (Field3) — bool
Deposit (보증금)
- id (Key) — bigint — Primary key — NOT NULL
- amount (Field) — bigint
- ascent_defence (Field2) — bigint
- descent_assignemnt (Field3) — bigint
- descent_attendance (Field4) — bigint
- id (Key2) — bigint — Foreign key → users.id — NOT NULL
users (유저)
- id (Key) — bigint — Primary key — NOT NULL
- password (Field) — char(255)
- email (Field2) — char(255)
- generation (Field3) — bigint