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