BookPrj

Tables (3)

OrderDetail (Untitled3)

  • Key (o_number) — INTEGER — Foreign key → Orders.Key — NOT NULL
  • Key (u_id) — varchar(255) — Foreign key → Orders.Key — NOT NULL
  • Field (od_count) — INTEGER
  • Field

Orders (Untitled2)

  • Key (o_number) — INTEGER — Primary key — NOT NULL
  • Key (u_id) — varchar(255) — Foreign key → User.Key — NOT NULL
  • Field (o_count) — INTEGER
  • Field (o_date) — DATE
  • Field (o_status) — varchar(255)
  • Field (o_total) — INTEGER

User (Untitled)

  • Key (u_id) — varchar(255) — Primary key — NOT NULL
  • Field (u_pw) — varchar(255)
  • Field (u_name) — varchar(255)
  • Field (u_phone) — varchar(255)
  • Field (u_email) — varchar(255)
  • Field (u_address) — varchar(255)
  • Field (u_isAdmin) — Boolean — NOT NULL