test

Tables (4)

order (주문)

  • order_id (Key) — bigint — Primary key — NOT NULL
  • user_id (id) — bigint — Foreign key → user.user_id — NOT NULL
  • date (Field) — datetime — NOT NULL

order_product (주문 관리)

  • order_product_id (Key) — int — Primary key — NOT NULL
  • product_id (Key2) — bigint — Foreign key → product.product_id — NOT NULL
  • order_id (Key3) — int — Foreign key → order.order_id — NOT NULL
  • quantity (Field) — bigint — NOT NULL

product (상품)

  • product_id (Key) — bigint — Primary key — NOT NULL
  • user_id (id) — bigint — Foreign key → user.user_id — NOT NULL
  • product_name (Field) — varchar(255) — NOT NULL
  • price (Field2) — bigint — NOT NULL

user (회원)

  • user_id (id) — bigint — Primary key — NOT NULL
  • user_name (name) — varcher(255) — NOT NULL
  • user_email (email) — varchar(255)
  • password (비밀 번호) — varchar(255) — NOT NULL
  • type (판매자 회원 구분) — varchar(10) — NOT NULL