ㅇㄹㄴㅎ
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