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)