팽귄뱅크
테이블 (6)
Notice (NOTICE)
- Key (NNUM) — NUMBER — 기본 키 — NOT NULL
- Field (TITLE) — VARCHAR2(30)
- Field (CONTENTS) — VARCHAR2(1500)
- Field (VNUM) — VARCHAR2(30)
- Field (NDATE) — VARCHAR2(30)
- Key (MEMBER_EMAIL) — VARCHAR2(40) — 외래 키 → Untitled.Key — NOT NULL
Untitled (FILEINFO)
- Key (FNUM) — NUMBER — 기본 키 — NOT NULL
- Field (FNAME) — VARCHAR2(30)
- Field (FSIZE) — VARCHAR2(30)
- Field (FPLACE) — VARCHAR2(30)
- Key (NOTICE_NNUM) — NUMBER — 외래 키 → Notice.Key — NOT NULL
Untitled (MEMBER)
- Key (EMAIL) — VARCHAR2(40) — 기본 키 — NOT NULL
- Field (PASSWORD) — VARCHAR2(40)
- Field (NAME) — VARCHAR2(30)
- Field (PHONE) — VARCHAR2(30)
- Field (PERNUM) — VAHRCARH2(30)
Untitled (ACCOUNT)
- Key (ACCNUM) — VARCHAR2(40) — 기본 키 — NOT NULL
- Field (MONEY) — VARCHAR2(30)
- Field (PASSWORD) — VARCHAR2(30)
- Field (BANKNAME) — VARCHAR2(30)
- Key (MEMBER_EMAIL) — VARCHAR2(40) — 외래 키 → Untitled.Key — NOT NULL
Untitled (TIMELINE)
- Key (TIMENUM) — NUMBER — 기본 키 — NOT NULL
- Field (TRADER) — VARCHAR2(40)
- Field (SENTMONEY) — VARCHAR2(30)
- Field (RECEIVEMONEY) — VARCHAR2(30)
- Field (WHENTIME) — VARCHAR2(30)
- Key (ACCOUNT_ACCNUM) — VARCHAR2(40) — 외래 키 → Untitled.Key — NOT NULL
Untitled (ACCOUNTDETAIL)
- Key (ACCDETAILNUM) — NUMBER — 기본 키 — NOT NULL
- Field (ACCTYPE) — VARCHAR2(30)
- Field2 (PAYMENTAMOUNT) — VARCHAR2(30)
- Field (APR) — VARCHAR2(30)
- Field2 (PAYMONTH) — VARCHAR2(30)
- Field (PAYMENTDAY) — VARCHAR2(30)
- Field (MATURITYDATE) — VARCHAR2(30)
- Field (LASTPAYMENTDATE) — VARCHAR2(30)
- Key (ACCOUNT_ACCNUM) — VARCHAR2(40) — 외래 키 → Untitled.Key — NOT NULL