seek_qr_db
Tables (8)
archive (Archive)
- user_id (UserID) — int — Foreign key → user.id — NOT NULL
- artwork_id (ArtworkID) — int — Foreign key → artwork.id — NOT NULL
- access_date (AccessDate) — datetime — NOT NULL
- remote_addr (RemoteAddress) — varchar(15) — NOT NULL
artwork (Artwork)
- id (ArtworkID) — int — Primary key — NOT NULL
- name (ArtworkName) — varchar(255) — NOT NULL
- artist (ArtworkArtist) — varchar(255) — NOT NULL
- sns (ArtworkSNS) — longtext
- archive_count (ArchiveCount) — int — NOT NULL
- history_count (Field) — int — NOT NULL
- year (Year) — int — NOT NULL
- dimension (Dimension) — varchar(255)
- material (Material) — varchar(255)
- information (Information) — longtext
- color (Field2) — varchar(15) — NOT NULL
- deleted (Deleted) — bit(1) — NOT NULL
comment (Comment)
- id (CommentID) — int — Primary key — NOT NULL
- artwork_id (ArtworkID) — int — Foreign key → artwork.id — NOT NULL
- user_id (UserID) — int — Foreign key → user.id — NOT NULL
- body (Body) — longtext
- like_count (LikeCount) — int — NOT NULL
- create_ip (CreateIP) — varchar(15) — NOT NULL
- create_date (CreateDate) — datetime — NOT NULL
- last_update_ip (LastUpdateIP) — varchar(15) — NOT NULL
- delete_date (DeleteDate) — datetime
- deleted (Deleted) — bit(1) — NOT NULL
history (History)
- user_id (UserID) — int — Foreign key → user.id — NOT NULL
- artwork_id (ArtworkID) — int — Foreign key → artwork.id — NOT NULL
- access_date (AccessDate) — datetime — NOT NULL
- remote_addr (RemoteAddress) — varchar(15) — NOT NULL
like_comment (Untitled)
- user_id (CommentID) — int — Foreign key → comment.id — NOT NULL
- comment_id (UserID) — int — Foreign key → user.id — NOT NULL
- access_date (Field) — datetime — NOT NULL
- remote_addr (Field2) — varchar(15) — NOT NULL
oauth (Untitled2)
- provider (Field2) — varchar(15) — Primary key — NOT NULL
- user_id (UserID) — int — Foreign key → user.id — NOT NULL
- access_token (Field) — varchar(255) — NOT NULL
- salt (Field3) — varchar(15) — NOT NULL
- provider_id (Field4) — varchar(255)
session (Session)
- id (SessionID) — int — Primary key — NOT NULL
- user_id (UserID) — int — Foreign key → user.id — NOT NULL
- access_date (AccessDate) — datetime — NOT NULL
- remote_addr (RemoteAddress) — varchar(15) — NOT NULL
user (User)
- id (UserID) — int — Primary key — NOT NULL
- nickname (UserNickname) — varchar(255) — NOT NULL
- account_expired (AccountExpired) — bit(1) — NOT NULL
- account_locked (AccountLocked) — bit(1) — NOT NULL
- create_ip (CreateIP) — varchar(15) — NOT NULL
- create_date (CreateDate) — datetime — NOT NULL
- withdraw_date (WithdrawDate) — datetime
- withdrawn (Withdrawn) — bit(1) — NOT NULL
- session_count (AccessCount) — int — NOT NULL