sosulFirst
Tables (3)
member (Untitled)
- m_id (회원아이디) — int — Primary key — NOT NULL
- subject (제목) — varchar(100)
- m_grade (회원구분) — char(1)
order (Untitled2)
- or_id (주문번호) — int — Primary key — NOT NULL
- m_id (회원아이디) — int — Foreign key → member.m_id — NOT NULL
- pr_id (제품아이디) — smallint — Foreign key → product.pr_id — NOT NULL
product (CopyOfUntitled)
- pr_id (제품아이디) — smallint — Primary key — NOT NULL
- pr_nm (제품명) — varchar(100)
- price (가격) — int