도서

테이블 (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