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)