project1

Tables (4)

orders (주문)

  • id (주문번호) — BIGINT — Primary key — NOT NULL
  • user_id (회원아이디) — BIGINT — Foreign key → user.id — NOT NULL
  • success_yn (성공여부) — ENUM('y', 'n') — NOT NULL
  • order_date (주문날짜) — DATE — NOT NULL
  • order_price (주문가격) — BIGINT — NOT NULL

product (제품)

  • id (물건번호) — BIGINT — Primary key — NOT NULL
  • seller_id (판매자아이디) — BIGINT — Foreign key → user.id — NOT NULL
  • product_name (물건이름) — VARCHAR(200) — NOT NULL
  • stock (재고) — INT — NOT NULL
  • price (가격) — INT — NOT NULL

product_orders_list (제품주문리스트)

  • id (Key) — BIGINT — Primary key — NOT NULL
  • order_id (주문번호) — BIGINT — Foreign key → orders.id — NOT NULL
  • product_id (물건번호) — BIGINT — Foreign key → product.id — NOT NULL
  • quantity (수량) — INT — NOT NULL

user (회원)

  • id (아이디) — BIGINT — Primary key — NOT NULL
  • name (이름) — VARCHAR(200) — NOT NULL
  • seller_yn (판매자여부) — ENUM('y', 'n') — NOT NULL
  • email (이메일) — VARCHAR(200)
  • phone (핸드폰번호) — VARCHAR(200)
  • pwd (비밀번호) — VARCHAR(200) — NOT NULL