simple-mall-erd
Tables (9)
AdminLog (Untitled9)
- id (Key) — BIGINT — Primary key — NOT NULL
- admin_id (Key2) — BIGINT — Foreign key → User.id — NOT NULL
- action (작업내용) — VARCHAR(100)
- target_id (영향을 받은 ID) — BIGINT
- timestamp (Field) — TIMESTAMP
Cart (Untitled3)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → User.id — NOT NULL
- product_id (Key3) — BIGINT — Foreign key → Product.id — NOT NULL
- quantity (담은 수량) — INT
Event (Untitled8)
- id (Key) — BIGINT — Primary key — NOT NULL
- title (Field) — VARCHAR(100)
- description (Field2) — TEXT
- start_date (Field3) — DATE
- end_date (Field4) — DATE
- admin_id (Key2) — BIGINT — Foreign key → User.id — NOT NULL
Notice (Untitled7)
- id (Key) — BIGINT — Primary key — NOT NULL
- title (Field) — VARCHAR(100)
- content (Field2) — TEXT
- admin_id (Key2) — BIGINT — Foreign key → User.id — NOT NULL
- created_at (Field3) — TIMESTAMP
Order (Untitled4)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → User.id — NOT NULL
- total_price (Field) — DECIMAL(10,2)
- status (Field2) — ENUM('pending', 'shipped', 'delivered', 'canceled')
- created_at (Field3) — TIMESTAMP
OrderItem (Untitled5)
- id (Key) — BIGINT — Primary key — NOT NULL
- product_id (Key2) — BIGINT — Foreign key → Product.id — NOT NULL
- order_id (Key3) — BIGINT — Foreign key → Order.id — NOT NULL
- quantity (Field) — INT
- price (Field2) — DECIMAL(10,2)
Payment (Untitled6)
- id (Key) — BIGINT — Primary key — NOT NULL
- order_id (Key2) — BIGINT — Foreign key → Order.id — NOT NULL
- payment_method (Field) — ENUM('credit_catrd', 'paypal', 'bank_transfer')
- status (Field2) — ENUM('paid', 'failed', 'refunded')
- paid_at (Field3) — TIMESTAMP
Product (Untitled2)
- id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR(100)
- price (Field2) — DECIMAL(10,2)
- stock (Field3) — INT
- category_id (Field4) — BIGINT
- description (Field5) — TEXT
- created_at (Field6) — TIMESTAMP
- updated_at (Field7) — TIMESTAMP
User (Untitled)
- id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR(50)
- email (Field2) — VARCHAR(100)
- password (Field3) — VARCHAR(255)
- role (Field4) — ENUM('admin', 'customer')
- created_at (Field5) — TIMESTAMP