토이프로젝트 6조
테이블 (10)
asset_statistics (Untitled9)
- id (Key2) — INT — 외래 키 → assets.id — NOT NULL
- recent_lent (Field) — INT — NOT NULL
- average_lent_duration (Field2) — INT — NOT NULL
assets (Untitled2)
- id (Key) — INT — 기본 키 — NOT NULL
- name (Field) — VARCHAR(50) — NOT NULL
- status (Field2) — INT — avaliable 0, checked out 1
- description (Field3) — VARCHAR(500)
- available_quantity (Field4) — int — NOT NULL
- location (Field5) — VARCHAR(100)
- created_at (Field6) — DATETIME — NOT NULL
- category_id (Key3) — INT — 외래 키 → category.id — NOT NULL
- club_id (Key2) — INT — 외래 키 → club.id — NOT NULL
category (Untitled8)
- id (Key) — INT — 기본 키 — NOT NULL
- name (Field) — VARCHAR(50) — NOT NULL
club (Untitled3)
- id (Key) — INT — 기본 키 — NOT NULL
- name (Field) — VARCHAR(50) — NOT NULL
- club_code (Field3) — VARCHAR(50)
- description (Field2) — VARCHAR(255)
favorite (Untitled6)
- id (Key3) — INT — 기본 키 — NOT NULL
- user_id (Key) — VARCHAR(36) — 외래 키 → user.id — NOT NULL
- asset_id (Key2) — INT — 외래 키 → assets.id — NOT NULL
picture (Untitled4)
- id (Key) — INT — 기본 키 — NOT NULL
- date (Field) — DATETIME — NOT NULL
- assets_id (Key2) — INT — 외래 키 → assets.id — NOT NULL
- user_id (Key3) — VARCHAR(36) — 외래 키 → user.id — NOT NULL
- category_id (Key4) — INT — 외래 키 → category.id — NOT NULL
- is_main (Field2) — BOOLEAN — NOT NULL
refresh_token (Untitled10)
- id (Key) — INT — 기본 키 — NOT NULL
- token (Field) — VARCHAR(255) — NOT NULL
- expires_at (Field2) — DATETIME — NOT NULL
- created_at (Field3) — DATETIME — NOT NULL
- user_id (Key2) — VARCHAR(36) — 외래 키 → user.id — NOT NULL
schedule (Untitled5)
- id (Key2) — INT — 기본 키 — NOT NULL
- start_date (Field) — DATETIME — NOT NULL
- end_date (Field2) — DATETIME — NOT NULL
- asset_id (Key) — INT — 외래 키 → assets.id — NOT NULL
- user_id (Key3) — VARCHAR(36) — 외래 키 → user.id — NOT NULL
- club_id (Key4) — INT — 외래 키 → club.id — NOT NULL
- status (Field3) — VARCHAR(20) — NOT NULL — "pending" "approved" "in_use" "returned" "cancelled"
user (Untitled)
- id (Key) — VARCHAR(36) — 기본 키 — NOT NULL
- name (Field) — VARCHAR(50) — NOT NULL
- email (Field2) — VARCHAR(50)
- hashed_password (Field3) — VARCHAR(64)
- social_email (Field4) — VARCHAR(50)
- is_admin (Field5) — BOOLEAN — NOT NULL
- student_id (Field6) — VARCHAR(10)
user_clublist (Untitled7)
- id (Key) — INT — 기본 키 — NOT NULL
- user_id (Key2) — VARCHAR(36) — 외래 키 → user.id — NOT NULL
- club_id (Key3) — INT — 외래 키 → club.id — NOT NULL
- permission (Field) — INT — NOT NULL — user 0, admin 1, applicant 2