user, product

okky erd

Tables (8)

Copy Of Untitled (product_hashtag_mapping)

  • Key (product_id) — bigint(20) — Primary key — NOT NULL
  • Key2 (hashtag_id) — bigint(20) — Primary key — NOT NULL
  • Field (create_ymdt) — datetime — NOT NULL

Untitled (product)

  • Key (id) — bigint(20) — Primary key — NOT NULL
  • id (user_id) — bigint(20) — Foreign key → user.id — NOT NULL
  • Field (product_name) — varchar(255) — NOT NULL
  • Field2 (cost) — bigint(20)
  • Field (sales_url) — varchar(1000)
  • Field3 (description) — varchar(255)
  • Field (create_ymdt) — datetime — NOT NULL
  • Field (modify_ymdt) — datetime — NOT NULL

Untitled (product_image_mapping)

  • Key (product_id) — bigint(20) — Primary key — NOT NULL
  • Key2 (image_id) — bigint(20) — Primary key — NOT NULL
  • Key (create_ymdt) — datetime — NOT NULL

follow

  • Key (follwer_id) — bigint(20) — Primary key — NOT NULL
  • follwing_id — bigint(20) — Primary key — NOT NULL
  • create_ymdt — datetime — NOT NULL

logged_in (login_history)

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • create_ymdt — datetime — NOT NULL
  • remote_addr — varchar(255) — NOT NULL

role

  • id — bigint(20) — Primary key — NOT NULL
  • authority — varchar(255) — NOT NULL

user

  • id — bigint(20) — Primary key — NOT NULL
  • password — varchar(255) — NOT NULL
  • account_locked (account_locked_yn) — char(1) — NOT NULL
  • account_expired (account_expired_yn) — char(1) — NOT NULL
  • enabled (use_yn) — char(1) — NOT NULL
  • username (user_name) — varchar(15) — NOT NULL
  • nickname — varchar(50) — NOT NULL
  • phone — varchar(12)
  • address — varchar(255)
  • birthday — char(10)
  • sex — char(1) — 'F' 'M'
  • picture — varchar(255)
  • date_created (create_ymdt) — datetime — NOT NULL
  • last_updated (modify_ymdt) — datetime — NOT NULL
  • last_password_changed (password_modify_ymdt) — datetime — NOT NULL

user_role

  • user_id — bigint(20) — Foreign key → user.id — NOT NULL
  • role_id — bigint(20) — Foreign key → role.id — NOT NULL
  • Field (create_ymdt) — datetime — NOT NULL