seek_gallery

Tables (17)

archive_artwork (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

archive_exhibition (Untitled6)

  • user_id (UserID) — int — Foreign key → user.id — NOT NULL
  • exhibition_id (Key) — int — Foreign key → exhibition.id — NOT NULL
  • access_date (Field) — datetime — NOT NULL
  • remote_addr (Field2) — varchar(15) — NOT NULL

artist_tag (Untitled9)

  • tag (Field) — varchar(255) — Primary key — NOT NULL
  • artist_id (UserID) — int — Foreign key → user.id — NOT NULL

artwork (Artwork)

  • id (ArtworkID) — int — Primary key — NOT NULL
  • page_id (Field3) — varchar(255) — NOT NULL
  • artist_id (UserID) — int — Foreign key → user.id — NOT NULL
  • name (ArtworkName) — varchar(255) — NOT NULL
  • create_date (Field4) — datetime — NOT NULL
  • update_date (Field5) — datetime — NOT NULL
  • archive_count (ArchiveCount) — int — NOT NULL
  • history_count (Field) — int — NOT NULL
  • year (Year) — int — NOT NULL
  • dimension (Dimension) — varchar(255)
  • dimensional (Field6) — bit(1) — NOT NULL
  • material (Material) — varchar(255)
  • information (Information) — longtext
  • color (Field2) — varchar(15) — NOT NULL
  • is_video (Field7) — int
  • deleted (Deleted) — bit(1) — NOT NULL

artwork_list (Untitled4)

  • exhibition_id (Key) — int — Foreign key → exhibition.id — NOT NULL
  • artwork_id (ArtworkID) — int — Foreign key → artwork.id — NOT NULL
  • access_date (Field) — datetime — NOT NULL
  • category (Field2) — varchar(255)

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

exhibition (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • owner_id (UserID) — int — Foreign key → user.id — NOT NULL
  • page_id (Field3) — varchar(255) — NOT NULL
  • name (Field) — varchar(255) — NOT NULL
  • information (Field2) — longtext — NOT NULL
  • link (Field10) — json
  • create_date (Field6) — datetime — NOT NULL
  • update_date (Field7) — datetime — NOT NULL
  • start_date (Field11) — date
  • end_date (Field12) — date
  • archive_count (Field8) — int — NOT NULL
  • history_count (Field5) — int — NOT NULL
  • is_video (Field9) — int
  • deleted (Field4) — bit(1) — NOT NULL

exhibition_collaborator (Untitled5)

  • exhibition_id (UserID) — int — Foreign key → user.id — NOT NULL
  • artist_id (Key) — int — Foreign key → exhibition.id — NOT NULL
  • access_date (Field) — datetime — NOT NULL
  • remote_addr (Field2) — varchar(15) — 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

location (Untitled7)

  • exhibition_id (Key) — int — Foreign key → exhibition.id — NOT NULL
  • latitude (Field) — decimal(18, 15) — NOT NULL
  • longitude (Field2) — decimal(18, 15) — NOT NULL
  • location_id (Field3) — int
  • area (Field4) — varchar(255)

love_artist (Untitled10)

  • artist_id (UserID) — int — Foreign key → user.id — NOT NULL
  • user_id (SessionID) — int — Foreign key → session.id — NOT NULL
  • access_date (Field) — datetime — NOT NULL
  • remote_addr (Field2) — varchar(15) — NOT NULL

love_exhibition (Untitled11)

  • exhibition_id (Key) — int — Foreign key → exhibition.id — NOT NULL
  • user_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
  • provider_id (Field4) — varchar(255)

represent_artwork (Untitled8)

  • artist_id (UserID) — int — Foreign key → user.id — NOT NULL
  • artwork_id (ArtworkID) — int — Foreign key → artwork.id — NOT NULL

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
  • page_id (Field) — varchar(255) — 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
  • sns (Field2) — longtext
  • youtube (Field4) — longtext
  • instagram (Field5) — longtext
  • twitter (Field6) — longtext
  • information (Field7) — longtext
  • mail (Field8) — longtext
  • verified (Field3) — bit(1) — NOT NULL