토이프로젝트 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