OTP

Tables (7)

Untitled (otp_kko)

  • Key (otp_kkoNo) — int — Primary key — NOT NULL
  • Key (member_no) — int — Foreign key → Untitled2.Key — NOT NULL
  • Field (otp_accessToken) — varchar(300) — NOT NULL
  • Field (otp_refreshToken) — varchar(300) — NOT NULL
  • Field (otp_exprieTime) — date — NOT NULL

Untitled (otp_profile)

  • Key (otp_profile_no) — int — Primary key — NOT NULL
  • Key (member_no) — int — Foreign key → Untitled2.Key — NOT NULL
  • Field (otp_profile_contents) — json — NOT NULL
  • Field (otp_profile_update) — date — NOT NULL

Untitled (otp_member_lol)

  • Key (otp_lol_no) — int — Primary key — NOT NULL
  • Key (member_no) — int — Foreign key → Untitled2.Key — NOT NULL
  • Field (otp_lol_id) — varchar(100) — NOT NULL
  • Field (otp_lol_accountId) — varchar(100) — NOT NULL
  • Field (otp_lol_puuid) — varchar(200) — NOT NULL

Untitled (otp_freeboard)

  • Key (otp_board_no) — int — Primary key — NOT NULL
  • Key (member_no) — int — Foreign key → Untitled2.Key — NOT NULL
  • Field (otp_board_subject) — varchar(100) — NOT NULL
  • Field (otp_board_content) — varchar(3000) — NOT NULL
  • Field (otp_board_writedate) — date — NOT NULL

Untitled (otp_board_like)

  • Key (otp_like_no) — int — Primary key — NOT NULL
  • Field

Untitled (otp_lol_info)

  • Key (otp_lol_info_no) — int — Primary key — NOT NULL
  • Field

Untitled2 (OTP_MEMBER)

  • Key (member_no) — int — Primary key — NOT NULL
  • Field (member_id) — varchar(30) — NOT NULL
  • Field (member_pwd) — varchar(100) — NOT NULL
  • Field (member_nick) — varchar(50) — NOT NULL