silver

Tables (4)

company (기업)

  • C_NAME (기업명) — VARCHAR2(50) — Primary key — NOT NULL
  • C_NUM (전화번호) — VARCHAR2(15)
  • C_NUM2 (전화번호2) — VARCHAR2(11)
  • C_ADDR (주소) — VARCHAR2(15)
  • C_USER (아이디) — VARCHAR2(15)
  • C_PASSWORD (비밀번호) — VARCHAR2(15)
  • C_EMAIL (회사이메일) — VARCHAR2(50)

order_history (주문내역)

  • ID (아이디) — VARCHAR2(15) — Foreign key → user_info.ID
  • C_NAME (기업명) — VARCHAR2(50) — Foreign key → product.C_NAME — NOT NULL
  • P_NAME (상품명) — VARCHAR2(15)
  • P_PRICE (가격) — VARCHAR2(15)
  • ADDR (주소) — VARCHAR2(15) — NOT NULL
  • PHONE_NUM (핸드폰) — VARCHAR2(11)
  • EMAIL (이메일) — VARCHAR2(50)

product (상품)

  • C_NAME (기업명) — VARCHAR2(50) — Foreign key → company.C_NAME — NOT NULL
  • P_NAME (상품명) — VARCHAR2(15)
  • P_PRICE (가격) — VARCHAR2(15)
  • P_QUANTITY (수량) — VARCHAR2(15)

user_info (유저 정보)

  • ID (아이디) — VARCHAR2(15) — Primary key
  • PASSWORD (비밀번호) — VARCHAR2(15)
  • NAME (이름) — VARCHAR2(15)
  • PHONE_NUM (핸드폰) — VARCHAR2(15)
  • ADDR (주소) — VARCHAR2(255)
  • EMAIL (이메일) — VARCHAR2(50)