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