Dopamine_Killer

Tables (3)

Achievement (업적)

  • id (achievement_id) — NOT NULL — Primary key — NOT NULL
  • starter (중독 끊기 스타터) — NOT NULL
  • Field
  • Field2
  • id (apptime_id) — NOT NULL — Foreign key → AppTime.id — NOT NULL
  • id (user_id) — NOT NULL — Foreign key → AppTime.id — NOT NULL
  • id (achievement_id2) — NOT NULL — Foreign key → AppTime.id — NOT NULL

AppTime (앱 타임)

  • id (apptime_id) — NOT NULL — Primary key — NOT NULL
  • id (user_id) — NOT NULL — Foreign key → User.id — NOT NULL
  • id (achievement_id) — NOT NULL — Foreign key → User.id — NOT NULL
  • instagram_time (인스타그램 사용시간) — NOT NULL
  • youtube_time (유튜브 사용시간) — NOT NULL
  • Field
  • Field2
  • Field3

User (회원)

  • id (user_id) — NOT NULL — Primary key — NOT NULL
  • id (achievement_id) — NOT NULL — Foreign key → Achievement.id — NOT NULL
  • login_id (로그인 아이디) — NOT NULL
  • password (비밀번호) — NOT NULL
  • name (이름) — NOT NULL