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