0808_ERD
Tables (10)
Authentic
- auth_no — int — Primary key — NOT NULL
- user_no — int — Foreign key → User.user_no — NOT NULL
- gender — int
- phone — varchar(128)
- email — varchar(128)
- birthdate — varchar(128)
- auth_date — datetime
- address — varchar(128)
Password
- password_no — int — Primary key — NOT NULL
- user_no — int — Foreign key → User.user_no — NOT NULL
- salt — varchar(128)
- password — varchar(128)
- update_date — datetime
Session
- login_no — int — Primary key — NOT NULL
- user_no — int — Foreign key → User.user_no — NOT NULL
- login_time — datetime
- logout_time — datetime
- ip_address — varchar(50)
- fail_count — int
- fail_reason — varchar(128)
- status_code — int
User
- user_no — int — Primary key — NOT NULL
- user_id — varchar(256)
UserProfile
- profile_no — int — Primary key — NOT NULL
- user_no — int — Foreign key → User.user_no — NOT NULL
- nickname — varchar(50)
- image_url — varchar(128)
- introduce — varchar(256)
slumberUser
- sl_user_no — int — Primary key — NOT NULL
- sl_user_id — varchar(128)
slumberUserAuthentic
- sl_auth_no — int — Primary key — NOT NULL
- sl_user_no — int — Foreign key → slumberUser.sl_user_no — NOT NULL
- sl_gender — int
- sl_phone — varchar(128)
- sl_email — varchar(128)
- sl_birthdate — varchar(128)
- sl_auth_date — datetime
- sl_address — varchar(128)
slumberUserPassword
- sl_password_no — int — Primary key — NOT NULL
- sl_user_no — int — Foreign key → slumberUser.sl_user_no — NOT NULL
- sl_salt — varchar(128)
- sl_password — varchar(128)
- sl_update_date — datetime
slumberUserProfile
- sl_profile_no — int — Primary key — NOT NULL
- sl_user_no — int — Foreign key → slumberUser.sl_user_no — NOT NULL
- sl_nickname — varchar(50)
- sl_image_url — varchar(128)
- sl_introduce — varchar(256)
withdrawalUserlog
- wu_log_no — int — Primary key — NOT NULL
- ci — varchar(128)
- wu_status_code — int
- wu_reason — varchar(128)
- wu_date — datetime
- wu_id — varchar(128)