sim

Tables (6)

authority (Untitled2)

  • Key (authority_id) — Primary key — NOT NULL
  • Field (name)
  • Field (reg_dt)
  • Field2 (edit_dt)
  • Field (reg_user)
  • Field (edit_user)

authority_history (Untitled5)

  • Key (authority_history_id) — Primary key — NOT NULL
  • Key (authority_id) — Foreign key → authority.Key — NOT NULL
  • Field (history)
  • Field (reg_user)
  • Field (reg_dt)

member (회원)

  • Key (member_id) — Primary key — NOT NULL
  • Field (password)
  • Field (name)
  • Field (contact)
  • Field (email)
  • Field (status)
  • Field (reg_dt)
  • Field (edit_dt)

member_authority (Untitled)

  • Key (member_id) — Foreign key → member.Key — NOT NULL
  • Key (authority_id) — Foreign key → authority.Key — NOT NULL

member_authority_history (Untitled4)

  • Key (member_authority_history_id) — Primary key — NOT NULL
  • Key (member_id) — Foreign key → member_authority.Key — NOT NULL
  • Key (authority_id) — Foreign key → member_authority.Key — NOT NULL
  • Field (history)
  • Field (reg_user)
  • Field (reg_dt)

member_history (Untitled3)

  • Key (member_history_id) — Primary key — NOT NULL
  • Key (member_id) — Foreign key → member.Key — NOT NULL
  • Field (history)
  • Field (reg_user)
  • Field (reg_dt)