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)

  • Field

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