emoney

Tables (3)

Account

  • accnt_id (Field) — number — Primary key
  • nickname (Field2) — varchar2(20)
  • name (Field3) — varchar2(20)
  • user_type (Field4) — varchar2(12)
  • phone (Field5) — char(13)
  • id (Field6) — varchar2(16)
  • s_passwd (Field7) — varchar2(64)
  • last_loginDate (Field8) — varchar2(30)
  • salt (Field9) — varchar2(17)

Board (board)

  • post_num (Key) — number — Primary key — NOT NULL
  • accnt_id (writer) — number — Foreign key → Account.accnt_id
  • title (Field) — varchar2(100)
  • content (Field2) — CLOB
  • time (Field4) — date

LOGIN_HISTORY

  • history_num (Key) — number — Primary key — NOT NULL
  • accnt_id (Field2) — number — Foreign key → Account.accnt_id
  • login_date (Field) — date
  • is_mobile (Field3) — char(1)
  • ip (Field4) — varchar2(39)
  • browser (Field5) — varchar2(20)
  • os (Field6) — varchar2(20)
  • Field7