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