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