voca

Tables (3)

USER (user)

  • 아이디 (user_id) — nvarchar2(40) — Primary key — NOT NULL
  • 패스워드 (password) — nvarchar2(20)
  • 닉네임 (nickname) — nvarchar2(10)
  • 유저이름 (user_name) — nvarchar2(10)
  • Field (gender) — nvarchar2(5)
  • 생년월일 (birth) — date

Untitled (voca)

  • Key (v_no) — varchar2(10) — Primary key — NOT NULL
  • Field (voca) — nvarchar2(20)
  • Field (sense) — nvarchar2(20)
  • 아이디 (user_id) — nvarchar2(40) — Foreign key → USER.아이디 — NOT NULL
  • Field (insert_date) — date

VOCABULRY (v_list)

  • 단어장 id (list_id) — varchar2(10) — Primary key — NOT NULL
  • 아이디 (user_id) — nvarchar2(40) — Foreign key → USER.아이디 — NOT NULL
  • Key (v_no) — varchar2(10) — Foreign key → Untitled.Key — NOT NULL
  • Field (list_name) — nvarchar2(20)
  • Field (inster_date) — date