weekify-be
Tables (3)
USERS (사용자)
- ID (Key) — BIGINT — Primary key — NOT NULL
- email (이메일) — VARCAHR(100)
- name (사용자 이름) — VARCHAR(50)
- tel (Field3) — VARCHAR(20)
- birth_day (생년월일) — DATE
- address (주소) — VARCHAR(255)
- profile_img_url (프로필 사진) — VARCAHR(500)
- is_active (계정 활성화) — BOOLEAN
- created_at (생성일) — TIMESTAMP
- updated_at (수정일) — TIMESTAMP
USER_AOUTH_ACCOUNT (OAuth 로그인)
- ID — BIGINT — Primary key — NOT NULL
- USER_ID — BIGINT — Foreign key → USERS.ID — NOT NULL
- PROVIDER (OAuth 제공자) — VARCHAR(20)
- PROVIDER_ID (OAuth 유저 고유 식별자) — VARCHAR(255)
- CREATE_AT (생성일) — TIMESTAMP
- UPDATE_AT (수정일) — TIMESTAMP
USER_CREDENTIALS (일반로그인)
- ID (PK) — BIGINT — Primary key — NOT NULL
- USER_ID — BIGINT — Foreign key → USERS.ID — NOT NULL
- PASSWORD (비밀번호) — VARCHAR(255)
- CREATED_AT (생성일) — TIMESTAMP
- UPDATED_AT (수정일) — TIMESTAMP