ㅇㄹㄴㅎ

Tables (3)

Order (Untitled)

  • order_code (Key) — number — Primary key — NOT NULL
  • user_id (Field) — varchar2(255) not null
  • order_price (Field2) — number default 0

Order_item (Untitled2)

  • order_item_code (Key) — number — Primary key — NOT NULL
  • item_code (Key2) — number — Foreign key → item.item_code — NOT NULL
  • order_code (Key3) — number — Foreign key → Order.order_code — NOT NULL

item (Untitled3)

  • item_code (Key) — number — Primary key — NOT NULL
  • item_category (Field) — varchar2(255) not null
  • item_name (Field2) — varchar2(255) not null
  • item_price (Field3) — number default 0