Team9

Tables (5)

tb_center (지도)

  • id (Key) — int — Primary key — NOT NULL
  • map_address (Field) — varchar
  • lat (Field2) — float
  • lng (Field3) — float

tb_movie (모델과 비교할 영상)

  • id (Key) — int — Primary key — NOT NULL
  • upload_movie_url (Field) — varchar

tb_profile (프로필)

  • id (Key) — int — Primary key — NOT NULL
  • word_id (Key2) — int — Foreign key → tb_word.id — NOT NULL
  • user_id (Key3) — int — Foreign key → tb_user.id — NOT NULL
  • favorite (Field) — bool

tb_user (사용자)

  • id (Key) — int — Primary key — NOT NULL
  • email (Field) — varchar
  • name (Field2) — varchar

tb_word (번역단어)

  • id (Key) — int — Primary key — NOT NULL
  • word_name (Field) — varchar
  • description (Field2) — varchar
  • movie_url (Field3) — varchar
  • word_image (Field4)