shin
Tables (3)
member (Untitled)
- m_id (회원id) — int — Primary key — NOT NULL
- subject (first) — VARCHAR(100)
- m_grade (회원구분) — CHAR(1)
order (Untitled2)
- or_id (주문번호) — int — Primary key — NOT NULL
- m_id (회원id2) — int — Foreign key → member.m_id — NOT NULL
- pr_id (상품id2) — INT — Foreign key → product.pr_id — NOT NULL
product (CopyOfUntitled)
- pr_id (상품id) — int — Primary key — NOT NULL
- pr_nm (first) — VARCHAR(100)
- price (Field) — int