LAT

Tables (6)

AUTH (권한)

  • Id (아이디) — NOT NULL — Primary key — NOT NULL
  • access_token (엑세스토큰) — NOT NULL
  • refresh_token (리프레쉬토큰) — NOT NULL
  • created_at (생성일) — NOT NULL
  • updated_at (수정일) — NOT NULL
  • deleted_at (삭제일) — NOT NULL
  • member_id (유저 아이디) — NOT NULL — Foreign key → MEMBER.Id — NOT NULL

CALL_LOG (Untitled)

  • id (아이디) — NOT NULL — Primary key — NOT NULL
  • mebmer_id (유저아이디) — NOT NULL — Foreign key → MEMBER.Id — NOT NULL
  • converstation (대화) — NULL
  • call_started_at (통화 시작 시간) — NOT NULL
  • call_ended_at (통화 종료 시간) — NOT NULL
  • is_conneted (연결여부) — NOT NULL
  • created_at (생성일) — NOT NULL
  • updated_at (수정일) — NOT NULL
  • deleted_at (삭젱일) — NULL

CALL_SCHEDULE (일정)

  • id (아이디) — BIGINT — Primary key — NOT NULL
  • member_id (유저 아이디) — NOT NULL — Foreign key → MEMBER.Id — NOT NULL
  • status (상태) — NOT NULL
  • created_at (생성일) — NOT NULL
  • updated_at (수정일) — NOT NULL
  • deleted_at (삭제일) — NOT NULL

CALL_SCHEDULE_DETAIL (일정 상세)

  • id (아이디) — NOT NULL — Primary key — NOT NULL
  • call_schedule_id (저화 일정 아이디) — NOT NULL — Foreign key → CALL_SCHEDULE.id — NOT NULL
  • day_of_week (요일) — NOT NULL
  • call_time (시간) — NOT NULL
  • created_at (생성일) — NOT NULL
  • updated_at (수정일) — NOT NULL
  • deleted_at (삭제일) — NOT NULL

MEMBER (유저)

  • Id (아이디) — NOT NULL — Primary key — NOT NULL
  • name (이름) — NOT NULL
  • password (비밀빈호) — NOT NULL
  • phone (연락처) — NOT NULL
  • created_at (생성일) — NOT NULL
  • updated_at (수정일) — NOT NULL
  • deleted_at (삭제일) — NOT NULL

VERIFICATION (인증)

  • Id (아이디) — NOT NULL — Primary key — NOT NULL
  • code (코드) — NOT NULL
  • created_at (생성일) — NOT NULL
  • updated_at (수정일) — NOT NULL
  • deleted_at (삭제일) — NOT NULL
  • member_id (유저아이디) — NOT NULL — Foreign key → MEMBER.Id — NOT NULL