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