팽귄뱅크

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