bomifirst

Tables (3)

member (Untitled)

  • m_id (회원아이디) — int — Primary key — NOT NULL
  • subject (Field3) — 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 (Key2) — smallint — Foreign key → product.pr_id — NOT NULL

product (CopyOfUntitled)

  • pr_id (Key2) — smallint — Primary key — NOT NULL
  • pr_nm (Field3) — varchar(100)
  • price (Field) — int