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