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