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