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