test
Tables (8)
TB_DANGO
- dango_id — INT — Primary key — NOT NULL
- dango_name — VARCHAR2(50) — NOT NULL
- rarity — VARCHAR2(50) — NOT NULL
- location_img — VARCHAR2(255) — NOT NULL
TB_FRIEND
- user_id — INT — Primary key — NOT NULL
- following_id — INT — Primary key — NOT NULL
TB_JAPANESE
- japanese_id — INT — Primary key — NOT NULL
- words_id — INT — NOT NULL
- kanji — VARCHAR2(50)
- hiragana — VARCHAR2(50) — NOT NULL
- kanji_kr — VARCHAR2(50) — NOT NULL
- example — VARCHAR2(255) — NOT NULL
- example_kr — VARCHAR2(255) — NOT NULL
TB_SESSION
- study_id — INT — Primary key — NOT NULL
- japanese_id — INT — NOT NULL
- is_learned — NUMBER(1) — NOT NULL
TB_STUDY
- study_id — INT — Primary key — NOT NULL
- user_id — INT — NOT NULL
- words_id — INT — NOT NULL
- japanese_id — INT — NOT NULL
- study_date — DATE
- study_count — INT
TB_USER
- user_id — INT — Primary key — NOT NULL
- email — VARCHAR2(100) — NOT NULL
- password — VARCHAR2(100) — NOT NULL
- nickname — VARCHAR2(50) — NOT NULL
- name — VARCHAR2(50) — NOT NULL
- intro — VARCHAR2(255)
- study_time — DATE
- point — INT
TB_USER_DANGO
- user_id — INT — NOT NULL
- dango_id — INT — NOT NULL
- buy_date — DATE — NOT NULL
TB_WORDS
- words_id — INT — Primary key — NOT NULL
- words_name — VARCHAR2(50) — NOT NULL