ERD
Tables (4)
Transactions (Untitled4)
- client_id (Key) — varchar2() — Primary key — NOT NULL
- product_id (p_id) — varchar2() — Foreign key → product.product_id — NOT NULL
- Trans_date (Field) — date()
- trans_amount (Field2) — int()
area (Untitled3)
- product_id (p_id) — varchar2() — Foreign key → product.product_id — NOT NULL
- area_name (Field) — varchar2() — NOT NULL
product (Untitled2)
- product_id (p_id) — varchar2() — Primary key — NOT NULL
- user_id — varchar2() — Foreign key → user.user_id — NOT NULL
- p_name — varchar2() — NOT NULL
user (Untitled)
- user_id — varchar2() — Primary key — NOT NULL
- user_pw — varchar2() — NOT NULL
- user_email — varchar2() — NOT NULL