jaenee
Tables (3)
member (Untitled)
- m_id (회원아이디) — int — Primary key — NOT NULL
- subject (Field) — varchar(100)
- m_grade (회원구분) — char(1)
order (Untitled2)
- or_id (주문번호) — int — Primary key — NOT NULL
- m_id (회원아이디2) — int — Foreign key → member.m_id — NOT NULL
- pr_id (Key2) — smallint — Foreign key → product.pr_id — NOT NULL
product (CopyOfUntitled)
- pr_id (Key2) — smallint — Primary key — NOT NULL
- pr_nm (Field) — varchar(100)
- price (Field2) — int