SSURENT

Tables (7)

assists (대여사업도우미)

  • id (PK) — VARCHAR(8) — Primary key — NOT NULL
  • name (Field2) — VARCHAR(20)
  • created_at (Field4) — Datetime(6)
  • updated_at (Field5) — Datetime(6)
  • is_deleted (Field3) — bool
  • deleted_at (Field) — Datetime(6)

categories (카테고리테이블)

  • id (PK) — VARCHAR(8) — Primary key — NOT NULL
  • name (Field) — VARCHAR(20)
  • created_at (Field3) — Datetime(6)
  • updated_at (Field4) — Datetime(6)
  • is_deleted (Field5) — bool

items (물품 테이블)

  • id (PK) — VARCHAR(8) — Primary key — NOT NULL
  • category_id (FK) — VARCHAR(8) — Foreign key → categories.id — NOT NULL
  • name (Field) — VARCHAR(50)
  • item_num (Field2) — VARCHAR(10)
  • status (Field4) — ENUM("active","fixing","inactive")
  • created_at (Field5) — Datetime(6)
  • updated_at (Field6) — Datetime(6)
  • is_deleted (Field3) — bool
  • deleted_at (Field7) — Datetime(6)

items_status_log (물품 상태 변경 로그)

  • id (PK) — VARCHAR(8) — Primary key — NOT NULL
  • items_id (FK) — VARCHAR(8) — Foreign key → items.id — NOT NULL
  • chagned_by (FK2) — VARCHAR(8) — Foreign key → user.id — NOT NULL
  • previous_status (Field) — ENUM("active","fixing","inactive")
  • new_status (Field2) — ENUM("active","fixing","inactive")
  • created_at (Field3) — Datetime(6)

rental_history (대여 이력 테이블)

  • id (PK) — VARCHAR(8) — Primary key — NOT NULL
  • assist_id (FK3) — VARCHAR(8) — Foreign key → assists.id — NOT NULL
  • user_id (FK) — VARCHAR(8) — Foreign key → user.id — NOT NULL
  • item_id (FK2) — VARCHAR(8) — Foreign key → items.id — NOT NULL
  • rental_date (Field) — Datetime(6)
  • due_date (Field2) — Datetime(6)
  • return_date (Field3) — Datetime(6)
  • status (Field4) — ENUM("active","overdue","finished")
  • created_at (Field5) — Datetime(6)
  • updated_at (Field6) — Datetime(6)

user (유저테이블)

  • id (PK) — VARCHAR(8) — Primary key — NOT NULL
  • student_num (Field2) — VARCHAR(8)
  • name (Field) — VARCHAR(20)
  • ph_num (Field6) — VARCHAR(14)
  • status (Field3) — ENUM("active","banned")
  • created_at (Field4) — Datetime(6)
  • updated_at (Field5) — Datetime(6)
  • role (Field7) — ENUM("superadmin","admin","normal")
  • is_deleted (Field8) — bool
  • deleted_at (Field9) — Datetime(6)

user_penalty_log (징계 이력)

  • id (PK) — VARCHAR(8) — Primary key — NOT NULL
  • user_id (FK) — VARCHAR(8) — Foreign key → user.id — NOT NULL
  • items_id (FK3) — VARCHAR(8) — Foreign key → items.id — NOT NULL
  • history_id (FK4) — VARCHAR(8) — Foreign key → rental_history.id — NOT NULL
  • penalty_type (Field) — ENUM("반납기한 경과", "무단 사용",)
  • created_at (Field2) — Datetime(6)