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