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