Tran_DB
Tables (5)
detected_sentences (Untitled3)
- id (Key) — Integer(PK, AutoIncrement) — Primary key — NOT NULL
- id (Key2) — Integer(PK,AutoIncrement) — Foreign key → users.id — NOT NULL
- user_id (Field) — Integer(FK-> users.id, Not null)
- sentence (Field2) — Text(not null)
- created_at (Field3) — DateTime
- Field4
detected_words (Untitled4)
- id (Key) — Integer(PK,autoincrement) — Primary key — NOT NULL
- id (Key2) — Integer(PK, AutoIncrement) — Foreign key → detected_sentences.id — NOT NULL
- id (Key22) — Integer(PK,AutoIncrement) — Foreign key → detected_sentences.id — NOT NULL
- sentence_id (Field4) — Integer(FK->detected_sentences.id,not null)
- word (Field2) — String(Not null)
- category (Field5) — Enum('신조어', '한자어')
- created_at (Field3) — DateTime
translations (Untitled2)
- id (Key) — Integer(PK) — Primary key — NOT NULL
- id (Key2) — Integer(PK) — Foreign key → users.id — NOT NULL
- user_id (Field) — Integer(FK->users.id)
- input_text (Field2) — String
- translated_text (Field3) — String
- created_at (Field4) — DateTime
- Field5
users (Untitled)
- id (Key) — Integer(PK,AutoIncrement) — Primary key — NOT NULL
- google_id (Field) — String(Unique, Not Null)
- email (Field2) — String(Unique, Not Null)
- username (Field3) — String(Not Null)
- created_at (Field4) — DateTime(Default=현재시간)
- Field5
word_usage (독립적 관계(번역될때마다 count가 증가))
- id (Key) — Integer(PK,autoincrement) — Primary key — NOT NULL
- word (Field) — String(unique,not null)
- count (Field2) — Integer
- last_updated (Field3) — DateTime
- Field4