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)