p2

Tables (5)

Payment (Untitled4)

  • payment_id (autoincrement) — Primary key — NOT NULL
  • item (청구품목) — 255
  • invoice (청구서번호) — 255
  • leadtime (리드타임)
  • clients (발주처) — 255
  • order_qty (발주수량)
  • order_price (발주금액)
  • member_id (autoincrement2) — Foreign key → member.member_id — NOT NULL
  • item_id (autoincrement3) — Foreign key → item_info.item_id — NOT NULL

basket (Untitled)

  • basket_id (autoincrement) — Primary key — NOT NULL
  • item (청구품목) — 255
  • leadtime (리드타임)
  • billing_amount (청구량)
  • clients (발주처) — 255
  • esti_unit_price (견적단가)
  • member_id (autoincrement2) — Foreign key → member.member_id — NOT NULL
  • item_id (autoincrement3) — Foreign key → item_info.item_id — NOT NULL

item_info (Untitled2)

  • item_id (autoincrement) — Primary key — NOT NULL
  • subject — 255
  • machinery — 255
  • assembly — 255
  • items (청구품목) — 255
  • part1 — 255
  • part2 — 255
  • key2 — 255
  • leadtime (리드타임)
  • clients (발주처) — 255
  • esti_unit_price (견적단가)
  • currency (견적화폐) — 255

member (Untitled3)

  • member_id (autoincrement) — Primary key — NOT NULL
  • email (이메일) — 255
  • password (비밀번호) — 255
  • authority (권한) — 45

refresh_token (Untitled5)

  • rt_key — 255 — Primary key — NOT NULL
  • rt_value — 255