employee_purchase_0310
Tables (8)
ATTACHMENT
- attachment_id — BIGINT — Primary key — NOT NULL
- request_id — BIGINT — Foreign key → PURCHASE_REQUEST.request_id — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- file_size — BIGINT — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- file_type — VARCHAR(50) — NOT NULL
- upload_date — DATETIME — NOT NULL
- file_description — TEXT
- Key — Foreign key — NOT NULL
- Key (Key2) — Foreign key — NOT NULL
DELIVERY
- delivery_id — BIGINT — Primary key — NOT NULL
- request_id — BIGINT — Foreign key → PURCHASE_REQUEST.request_id — NOT NULL
- zip_code — CHAR(5) — NOT NULL
- delivery_location — VARCHAR(255) — NOT NULL
- address_detail — VARCHAR(100)
- recipient_name — VARCHAR(50) — NOT NULL
- recipient_phone — VARCHAR(20) — NOT NULL
- delivery_status — VARCHAR(20) — NOT NULL
- delivered_at — DATETIME
- Key — Foreign key — NOT NULL
- Key (Key2) — Foreign key — NOT NULL
DEPARTMENT
- dept_id (부서 고유 식별자) — BIGINT — Primary key — AUTO_INCREMENT
- dept_code — VARCHAR(20) — NOT NULL
- dept_name — VARCHAR(100) — NOT NULL
- use_yn — CHAR(1) — NOT NULL
EMPLOYEE
- employee_id — BIGINT — Primary key — NOT NULL
- employee_no — VARCHAR(20) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- dept_id — BIGINT — Foreign key → DEPARTMENT.dept_id — NOT NULL
- position — VARCHAR(50)
- email — VARCHAR(100)
- phone_number — VARCHAR(20) — NOT NULL
- use_yn — CHAR(1) — NOT NULL
- created_at — DATETIME — NOT NULL
PAYMENT
- payment_id — BIGINT — Primary key — NOT NULL
- request_id — BIGINT — Foreign key → PURCHASE_REQUEST.request_id — NOT NULL
- credit_card_number — VARCHAR(30) — NOT NULL
- credit_card_company — VARCHAR(50) — NOT NULL
- installment — INT — NOT NULL
- expiry_date — CHAR(7) — NOT NULL
- payment_amount — BIGINT — NOT NULL
- payment_date — DATETIME
- payment_status — VARCHAR(20) — NOT NULL
- Key — Foreign key — NOT NULL
- Key (Key2) — Foreign key — NOT NULL
PRODUCT
- product_id — BIGINT — Primary key — NOT NULL
- product_code — VARCHAR(20) — NOT NULL
- product_name — VARCHAR(200) — NOT NULL
- price — BIGINT — NOT NULL
- point — INT — NOT NULL
- category — VARCHAR(50)
- use_yn — CHAR(1) — NOT NULL
- created_at — DATETIME — NOT NULL
PURCHASE_REQUEST
- request_id — BIGINT — Primary key — NOT NULL
- doc_no — VARCHAR(30) — NOT NULL
- employee_id — BIGINT — Foreign key → EMPLOYEE.employee_id — NOT NULL
- dept_id — BIGINT — Foreign key → DEPARTMENT.dept_id — NOT NULL
- draft_date — DATE — NOT NULL
- total_point — BIGINT — NOT NULL
- total_amount — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
PUR_REQ_ITEM
- item_id — BIGINT — Primary key — NOT NULL
- request_id — BIGINT — Foreign key → PURCHASE_REQUEST.request_id — NOT NULL
- product_id — BIGINT — Foreign key → PRODUCT.product_id
- item_no — INT — NOT NULL
- product_code — VARCHAR(20) — NOT NULL
- product_name — VARCHAR(200) — NOT NULL
- quantity — INT — NOT NULL
- unit_price — BIGINT — NOT NULL
- point — BIGINT — NOT NULL
- amount — BIGINT — NOT NULL
- Key — Foreign key — NOT NULL
- Key (Key2) — Foreign key — NOT NULL