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