KUAAA

Tables (8)

attends (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • member_id (Key2) — Int — Foreign key → member.id — NOT NULL
  • event_id (Key3) — int — Foreign key → event.id — NOT NULL
  • id (Key22) — int — Foreign key → member.department_id — NOT NULL
  • createdAt (Field) — datetime
  • updatedAt (Field2) — datetime
  • deletedAt (Field3) — datetime

case (Untitled7)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar
  • location (Field2) — varchar

department (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar
  • college (Field2) — varchar

equipment (Untitled5)

  • id (Key) — int — Primary key — NOT NULL
  • case_id (Key2) — int — Foreign key → case.id — NOT NULL
  • type_id (Key3) — int — Foreign key → equipment_type.id — NOT NULL
  • createdAt (Field5) — datetime
  • updatedAt (Field6) — datetime
  • deletedAt (Field7) — datetime
  • name (Field4) — varchar
  • type (Field) — varchar
  • count (Field2) — int
  • description (Field3) — varchar

equipment_type (Untitled6)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar

event (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • createdAt (Field7) — datetime
  • updatedAt (Field8) — datetime
  • deletedAt (Field9) — datetime
  • name (Field6) — varchar
  • type (Field) — enum
  • year (Field2) — int — NOT NULL
  • month (Field3) — int
  • start_date (Field4) — datetime
  • end_date (Field5) — datetime

member (멤버)

  • id (Key) — Int — Primary key — NOT NULL
  • department_id (Key2) — int — Foreign key → department.id — NOT NULL
  • createdAt (Field8) — datetime
  • updatedAt (Field9) — datetime
  • deletedAt (Field10) — datetime
  • user_id (Field) — varchar
  • password (Field2) — varchar
  • role (Field6) — enum
  • is_active (Field5) — bool
  • name (Field3) — varchar
  • email (Field4) — varchar
  • student_id (Field7) — int

rental (Untitled8)

  • id (Key) — int — Primary key — NOT NULL
  • member_id (Key2) — Int — Foreign key → member.id — NOT NULL
  • equipment_id (Key3) — int — Foreign key → equipment.id — NOT NULL
  • id (Key22) — int — Foreign key → member.department_id — NOT NULL
  • createdAt (Field5) — datetime
  • updatedAt (Field6) — datetime
  • deletedAt (Field7) — datetime
  • start_date (Field) — datetime
  • end_date (Field2) — datetime
  • purpose (Field3) — varchar
  • state (Field4) — enum