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