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