OS

Tables (18)

Auth.cidi (Untitled2)

  • Key (cidi_id) — UNSIGNED INT — Primary key — NOT NULL
  • Key (user_no) — UNSIGNED INT — Foreign key → member.user.Key — NOT NULL
  • Field (ci) — VARCHAR(88)
  • Field (di) — VARCHAR(64)

Auth.password (Untitled3)

  • Key (password_id) — UNSIGNED INT — Primary key — NOT NULL
  • Key (user_no) — UNSIGNED INT — Foreign key → member.user.Key — NOT NULL
  • Field (salt) — VARCHAR(128)
  • Field (password) — VARCHAT(128)
  • Field (update_date) — DATETIME

Auth.social_login (Auth)

  • Key (social_login_id) — UNSIGNED INT — Primary key — NOT NULL
  • Key (user_no) — UNSIGNED INT — Foreign key → member.user.Key — NOT NULL
  • Field (social_code) — UNSIGNED INT
  • Field (access_token) — VARCHAR(256)
  • Field (update_date) — DATETIME

Copy Of member.user (CopyOfUntitled)

  • Key (user_no) — UNSIGNED INT — Primary key — NOT NULL
  • Field (user_name)

log.login_log (Untitled8)

  • Key (user_no) — UNSIGNED INT — Foreign key → member.user.Key — NOT NULL
  • Field (fail_count) — UNSIGNED INT
  • Field (fail_reason) — UNSIGNED INT
  • Field (ip) — UNSIGNED INT
  • Field (status_code) — UNSIGNED INT

member.authertication (Untitled7)

  • Key (authentication_id) — UNSIGNED INT — Primary key — NOT NULL
  • Key (user_no) — UNSIGNED INT — Foreign key → member.user.Key — NOT NULL
  • Field (email) — VARCHARR(30)
  • Field (sex) — UNSIGNED INT
  • Field (auth_data) — DATETIME
  • Field (gather_agree) — UNSIGNED INT
  • Field (cell_phone) — VARCHAR(30)
  • Field (birthday) — VARCHAR(128)

member.profile (Untitled4)

  • Key (profile_id) — UNSIGNED INT — Primary key — NOT NULL
  • Key (user_no) — UNSIGNED INT — Foreign key → member.user.Key — NOT NULL
  • Field (nickname) — VARCHAR(100)

member.profile_skillStack (Untitled6)

  • Key (profile_id) — UNSIGNED INT — Foreign key → member.profile.Key — NOT NULL
  • Key (skillStack_id) — UNSIGNED_INT — Foreign key → member.skillStack.Key — NOT NULL

member.skillStack (Untitled5)

  • Key (skillStack_id) — UNSIGNED_INT — Primary key — NOT NULL
  • Field (skill) — VARCHAR(15)

member.user (Untitled)

  • Key (user_no) — UNSIGNED INT — Primary key — NOT NULL
  • Field (user_name)

page.category (Untitled13)

    page.page_userPost (Untitled12)

    • Key (page_userPost_id) — UNSIGNED INT — Primary key — NOT NULL
    • Key (page_id) — UNSIGNED INT — Foreign key → page.project.Key — NOT NULL

    page.project (Untitled11)

    • Key (page_id) — UNSIGNED INT — Primary key — NOT NULL
    • Field (display_count) — UNSIGNED INT
    • Field (page_number) — UNSIGNED INT

    post (Untitled9)

    • Key (post_id) — UNSIGNED INT — Primary key — NOT NULL
    • Key (user_no) — UNSIGNED INT — Foreign key → member.user.Key — NOT NULL

    user.ownedItem (Untitled14)

    • Key (ownedItem_id) — UNSIGNED INT — Primary key — NOT NULL
    • Key (user_no) — UNSIGNED INT — Foreign key → member.user.Key — NOT NULL
    • Field (hair) — UNSIGNED INT
    • Field (eye) — UNSGINED INT
    • Field (effect) — UNSIGNED INT

    user_enteredUser (Untitled16)

    • Key (enteredUser_id) — UNSIGNED INT — Primary key — NOT NULL
    • Key (user_postIn_id) — UNSIGNED INT — Foreign key → user_postInner.Key — NOT NULL
    • Key (user_no) — UNSIGNED INT — Foreign key → Copy Of member.user.Key — NOT NULL

    user_postInner (Untitled10)

    • Key (user_postIn_id) — UNSIGNED INT — Primary key — NOT NULL
    • Key (post_id) — UNSIGNED INT — Foreign key → post.Key — NOT NULL
    • Field (title) — VARCHAR(128)
    • Field (body) — VARCHAR(1028)
    • Field (upload_date) — DATETIME
    • Field (recruit_total) — UNSIGNED INT
    • Field (entered_count) — UNSIGNED INT

    user_postOutter (Untitled15)

    • Key (user_postOut_id) — Primary key — NOT NULL
    • Key (post_id) — UNSIGNED INT — Foreign key → post.Key — NOT NULL
    • Key (user_no) — UNSIGNED INT — Foreign key → Copy Of member.user.Key — NOT NULL
    • Field (Title) — VARCHAR(128)