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