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