DB EX

Tables (7)

BANK (통장)

  • ACCOUNTNUM (계좌번호) — NUMBER — Primary key — NOT NULL
  • ID (아이디) — VARCHAR(200) — Foreign key → MEMBER.ID — NOT NULL
  • PRODUCTNUM (상품번호) — NUMBER — Foreign key → BANKBOOK.PRODUCTNUM — NOT NULL
  • BALANCE (전체잔액) — NUMBER
  • FIRSTOPEN (개설일) — DATE

BANKBOOK (상품들)

  • PRODUCTNUM (상품번호) — NUMBER — Primary key — NOT NULL
  • INTERESTRATE (이자율) — NUMBER(3, 2)
  • PRODUCTNAME (상품이름) — VARCHAR(200)
  • PRODECTDETAIL (상세내용) — VARCHAR(400)
  • PRODUCTSELL (판매여부) — VARCHAR(200)

CHECK (내역조회)

  • ACCOUNTNUM (계좌번호) — VARCHAR(200) — Foreign key → BANK.ACCOUNTNUM — NOT NULL
  • ID (아이디) — VARCHAR(200) — Foreign key → BANK.ID — NOT NULL
  • Key (상품번호) — NUMBER — Foreign key → BANK.PRODUCTNUM — NOT NULL
  • DEPOSIT (입금) — NUMBER
  • WITHDRAW (출금) — NUMBER

MEMBER (회원)

  • ID (아이디) — VARCHAR(200) — Primary key — NOT NULL
  • PW (비밀번호) — VARCHAR(200)
  • NAME (이름) — VARCHAR(200)
  • PHONE (전화번호) — VARCHAR(200)
  • EMAIL (이메일) — VARCHAR(200)
  • ADDRESS (주소) — VARCHAR(200)

MEMBER_ROLE (멤버권한)

  • ROLENUM (권한번호) — NUMBER — Foreign key → ROLE.ROLENUM — NOT NULL
  • ID (아이디) — VARCHAR(200) — Foreign key → MEMBER.ID — NOT NULL

ROLE (권한)

  • ROLENUM (권한번호) — NUMBER — Primary key — NOT NULL
  • ROLENAME (권한이름) — VARCHAR(200)

TRADE

  • Key (TRADENUM) — NUMBER — Primary key — NOT NULL
  • ACCOUNTNUM (계좌번호) — NUMBER — Foreign key → BANK.ACCOUNTNUM — NOT NULL
  • Field