도서
테이블 (12)
Book (Untitled4)
- book_id (Key) — INT — 기본 키 — NOT NULL
- pub_id (Key2) — INT — 외래 키 → publisher.pub_id — NOT NULL
- bname (Field) — VARCHAR(50)
- category (Field2) — VARCHAR(40)
- writer (Field3) — VARCHAR(50)
- block (Field4) — BOOLEAN
- price (Field5) — INT
- age_ban (Field6) — INT
Seller (CopyOfusers)
- user_seq — INT — 기본 키 — NOT NULL
- user_id (Field) — VARCHAR(45)
- pw (Field2) — VARCHAR(45)
- name (Field3) — VARCHAR(45)
- address (Field4) — VARCHAR(45)
- phone (Field6) — VARCHAR(30)
- Field7
buy (Untitled7)
- buy_id (Key) — INT — 기본 키 — NOT NULL
- stock_id (Key2) — INT — 외래 키 → stock.stock_id — NOT NULL
- user_seq — INT — 외래 키 → users.user_seq — NOT NULL
- totalPrice (Field) — INT
- Field2
buyList (Untitled8)
- buyList_id (Key) — INT — 기본 키 — NOT NULL
- buy_id (Key2) — INT — 외래 키 → buy.buy_id — NOT NULL
- book_id (Key3) — INT — 외래 키 → Book.book_id — NOT NULL
- price (Field) — INT
membership (Untitled)
- memsh_id (Key) — INT — 기본 키 — NOT NULL
- point_rate (Field) — INT
publisher (Untitled5)
- pub_id (Key) — INT — 기본 키 — NOT NULL
- pname (Field) — VARCHAR(50)
- phone (Field2) — VARCHAR(30)
stock (Untitled6)
- stock_id (Key) — INT — 기본 키 — NOT NULL
- book_id (Key2) — INT — 외래 키 → Book.book_id — NOT NULL
- user_seq — INT — 외래 키 → Seller.user_seq — NOT NULL
- cnt (Field) — INT
sub (Untitled3)
- sub_id (Key) — 기본 키 — NOT NULL
- user_seq — INT — 외래 키 → users.user_seq — NOT NULL
- sub_date (Field) — SYSDATE
subscribe (Untitled9)
- subscribe_id (Key2) — INT — 기본 키 — NOT NULL
- pub_id (Key) — INT — 외래 키 → publisher.pub_id — NOT NULL
- sub_fee (Field) — INT
subscribeList (Untitled11)
- sub_List (Key) — 기본 키 — NOT NULL
- subscribe_id (Key2) — INT — 외래 키 → subscribe.subscribe_id — NOT NULL
- user_seq — INT — 외래 키 → users.user_seq — NOT NULL
- Field
- Field2
- Field3
users
- user_seq — INT — 기본 키 — NOT NULL
- memsh_id (Key) — INT — 외래 키 → membership.memsh_id — NOT NULL
- user_id (Field) — VARCHAR(45)
- pw (Field2) — VARCHAR(45)
- name (Field3) — VARCHAR(45)
- address (Field4) — VARCHAR(45)
- phone (Field6) — VARCHAR(30)
- age (Field7) — INT
wallet (Untitled2)
- user_seq — INT — 외래 키 → users.user_seq — NOT NULL
- cash (Field) — INT