comento

Tables (32)

Admins

  • admin_id — INT
  • admin_name — VARCHAR(50) — NOT NULL
  • permissions — TEXT

Attendance

  • attendance_id (Key) — INT — Primary key — NOT NULL
  • employee_id (Key2) — INT — Foreign key → Employee.employee_id — NOT NULL
  • date — DATE
  • check_in — TIME
  • check_out — TIME

Categories

  • category_id (Key) — INT — Primary key — NOT NULL
  • category_name — VARCHAR(50) — NOT NULL

Category

  • category_id (Key) — INT — Primary key — NOT NULL
  • category_name — VARCHAR(50) — NOT NULL

Copy Of Salary (CopyOfCopyOfCopyOfCopyOfUntitled22)

  • leave_id (Key) — autoincrement — Primary key — NOT NULL
  • leave_start (Field2) — date
  • leave_end (Field) — date
  • leave_type (Field3) — string

Copy Of Salary2 (CopyOfCopyOfCopyOfCopyOfUntitled222)

  • attendance_id (Key) — autoincrement — Primary key — NOT NULL
  • date (Field) — date
  • check_in (Field2) — datetime
  • check_out (Field3) — datetime

Department

  • department_id (Key) — INT — Primary key — NOT NULL
  • department_name — VARCHAR(100)

Department (부서)

  • department_id (부서 id) — autoincrement — Primary key — NOT NULL
  • department_name (부서명) — string

Employee

  • employee_id (Key) — INT — Primary key — NOT NULL
  • first_name — VARCHAR(50)
  • last_name — VARCHAR(50)
  • department_id (Key3) — INT — Foreign key → Department.department_id — NOT NULL
  • position_id (Key2) — INT — Foreign key → Position.position_id — NOT NULL
  • email — VARCHAR(100)
  • phone — VARCHAR(20)
  • hire_date — DATE

Employee (직원)

  • employee_id (직원id) — autoincrement — Primary key — NOT NULL
  • first_name (이름) — string
  • last_name (성) — string
  • email (이메일) — string
  • phone (연락처) — string
  • hire_date (입사일) — date

Employee_Project

  • employee_project_id (Key) — INT — Primary key — NOT NULL
  • employee_id (Key2) — INT — Foreign key → Employee.employee_id — NOT NULL
  • project_id (Key3) — INT — Foreign key → Project.project_id — NOT NULL
  • assigned_date — DATE
  • role — VARCHAR(50)

Employee_Project (직원-프로젝트)

  • employee_project_id (직원-프로젝트 id) — autoincrement — Primary key — NOT NULL
  • assigned_date (배정일) — date
  • role (프로젝트 역할) — string

Leave

  • leave_id (Key) — INT — Primary key — NOT NULL
  • employee_id (Key2) — INT — Foreign key → Employee.employee_id — NOT NULL
  • leave_start — DATE
  • leave_end — DATE
  • leave_type — VARCHAR(50)

Order

  • order_id (Key) — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key
  • total_amount — INT — NOT NULL
  • created_at — DATETIME
  • INDEX — idx_created_at

Order_Items

  • order_item_id (Key) — INT — Primary key — NOT NULL
  • order_id — INT — Foreign key
  • product_id — INT — Foreign key

Orders

  • order_id (Key) — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key
  • total_amount — INT — NOT NULL
  • created_at — TIME

Position

  • position_id (Key) — INT — Primary key — NOT NULL
  • position_title — VARCHAR(100)

Product

  • product_id (Key2) — INT — Primary key — NOT NULL
  • category_id — INT — Foreign key
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • price — INT — NOT NULL
  • stock_quantity — INT
  • INDEX — idx_category

Products

  • product_id (Key) — INT — Primary key — NOT NULL
  • category_id — INT — Foreign key
  • product_name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • price — DECIMAL(10, 2) — NOT NULL
  • stock_quantity — INT

Project

  • project_id (Key) — INT — Primary key — NOT NULL
  • project_name — VARCHAR(100)
  • start_date — DATE
  • end_date — DATE

Project (프로젝트)

  • project_id (프로젝트id) — autoincrement — Primary key — NOT NULL
  • start_date (프로젝트 시작일) — date
  • end_date (프로젝트 종료일) — date

Recommendation_Log

  • log_id — BIGINT
  • user_id — INT — Foreign key
  • product_id — INT — Foreign key
  • recommended_at — DATETIME
  • INDEX — idx_recommended_at
  • INDEX — idx_user_log

Recommendation_Logs

  • log_id (Key2) — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key
  • product_id — INT — Foreign key
  • recommended_at — TIME

Review

  • review_id — INT
  • user_id — INT — Foreign key
  • product_id — INT — Foreign key
  • rating — INT
  • comment — TEXT — EX
  • created_at — DATETIME
  • INDEX — idx_product_rating
  • INDEX — idx_user_review

Reviews

  • review_id (Key) — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key
  • product_id — INT — Foreign key
  • rating — INT
  • comment — TEXT — EX
  • created_at — TIME

Salary (CopyOfCopyOfCopyOfUntitled22)

  • salary_id (Key) — autoincrement — Primary key — NOT NULL
  • amount (Field) — integer
  • start_date (Field3) — date
  • end_date (Field2) — date

Salary

  • salary_id (Key) — INT — Primary key — NOT NULL
  • employee_id (Key2) — INT — Foreign key → Employee.employee_id — NOT NULL
  • amount — INT
  • start_date — DATE
  • end_date — DATE

User

  • user_id (Key) — INT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • role — VARCHAR(20)
  • created_at — DATETIME

Users

  • user_id (Key) — INT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • user_name — VARCHAR(50) — NOT NULL
  • created_at — TIME
  • role (Field) — VARCHAR(50)

Wishlist

  • wishlist_id (Key) — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key
  • product_id — INT — Foreign key
  • created_at — DATETIME

Wishlists

  • wishlist_id (Key2) — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key
  • product_id — INT — Foreign key
  • created_at — TIME

position (직급)

  • position_id (직급id) — autoincrement — Primary key — NOT NULL
  • position_title (직급명) — string