seekDB_v.0.2.0

Tables (22)

advertisement (Untitled13)

  • page_id (Key) — varchar(255) — Primary key — NOT NULL
  • title (Field2) — varchar(255) — NOT NULL
  • subtitle (Field3) — varchar(255) — NOT NULL

artist (CopyOfCustomer Information)

  • id (User ID) — int(11) — Primary key — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
  • person_id (ID for person) — int(11) — Foreign key → person.id — NOT NULL
  • account_expired (Has the account expired) — bit(1) — NOT NULL
  • account_locked (Has the account locked) — bit(1) — NOT NULL
  • create_ip (IP who created the user account) — varchar(36) — NOT NULL
  • last_access_ip (Last remote address IP for user account) — varchar(36) — NOT NULL
  • create_date (Date when the account is created) — datetime — NOT NULL
  • access_date (Date when last access has been made) — datetime — NOT NULL
  • password_change_date (Last date when password has been changed) — datetime
  • withdraw_date (Date when the account is withdrawn) — datetime
  • password (Password for user account) — varchar(255) — NOT NULL — Hashed
  • password_expired (Has the password expired) — bit(1) — NOT NULL — Expired after 6 months
  • withdrawn (Has the user account withdrawn) — bit(1) — NOT NULL

artist_page (CopyOfUntitled4)

  • page_id (Key) — varchar(255) — Primary key — NOT NULL — 100000000 ~ MAX(UNSIGNED INT)
  • artist_id (User ID) — int(11) — Foreign key → artist.id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
  • username (Customer's name) — varchar(36) — NOT NULL — Duplicate accepted
  • nickname (Nickname) — varchar(36) — NOT NULL — Randomly created, Duplicate not accepted
  • bio (Biography) — varchar(255) — NOT NULL
  • follower_number (Number of followers) — int(11) — NOT NULL
  • like_count (Number of likes on total artworks) — int(11) — NOT NULL
  • bookmark_count (Field) — int(11) — NOT NULL
  • favorite_count (Number of selection for user's favorite artist) — int(11) — NOT NULL
  • hashtag_0 (Artist hashtag 1) — varchar(36)
  • hashtag_1 (Artist hashtag 2) — varchar(36)
  • hashtag_2 (Artist hashtag 3) — varchar(36)
  • external_link (External link for artist) — varchar(255)
  • favorite_artist_page_id_0 (Key2) — varchar(255) — Foreign key → artist_page.page_id — 100000000 ~ MAX(UNSIGNED INT)
  • favorite_artist_page_id_1 (Key3) — varchar(255) — Foreign key → artist_page.page_id — 100000000 ~ MAX(UNSIGNED INT)
  • favorite_artist_page_id_2 (Key4) — varchar(255) — Foreign key → artist_page.page_id — 100000000 ~ MAX(UNSIGNED INT)

artwork (Untitled7)

  • page_id (Key) — varchar(255) — Primary key — NOT NULL
  • artist_page_id (Key2) — varchar(255) — Foreign key → artist_page.page_id — NOT NULL — 100000000 ~ MAX(UNSIGNED INT)
  • artist_id (User ID) — int(11) — Foreign key → artist_page.artist_id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
  • owner_page_id (Key8) — varchar(255) — Foreign key → user_page.page_id — 100000000 ~ MAX(UNSIGNED INT)
  • owner_id (User ID2) — int(11) — Foreign key → user_page.user_id — 10000 ~ MAX (UNSIGNED INT)
  • seller_page_id (Key9) — varchar(255) — Foreign key → user_page.page_id — 100000000 ~ MAX(UNSIGNED INT)
  • seller_id (User ID3) — int(11) — Foreign key → user_page.user_id — 10000 ~ MAX (UNSIGNED INT)
  • pinned_reply_id (Key6) — int(11) — Foreign key → reply.id
  • form_id (Key3) — int(11) — Foreign key → artwork_form.id
  • subject_id (Key4) — int(11) — Foreign key → artwork_subject.id
  • style_id (Key5) — int(11) — Foreign key → artwork_style.id
  • keyword_id (Key7) — int(11) — Foreign key → artwork_keyword.id
  • create_ip (IP who created the artwork) — varchar(36) — NOT NULL
  • last_update_ip (IP who lastly update the artwork) — varchar(36) — NOT NULL
  • last_access_ip (IP who lastly access the artwork) — varchar(36) — NOT NULL — used for view count control
  • create_date (Date when the artwork created) — datetime — NOT NULL
  • update_date (Date when artwork updated) — datetime — NOT NULL
  • delete_date (Date when the artwork has been deleted) — datetime
  • last_access_date (Date of last access) — datetime — NOT NULL — used for view control
  • like_count (Total number of likes) — int(11) — NOT NULL
  • bookmark_count (Total number of bookmarks) — int(11) — NOT NULL
  • view_count (Total number of views) — int(11) — NOT NULL
  • share_count (Total number of share) — int(11) — NOT NULL
  • price (Price of the artwork) — int(11) — NOT NULL
  • artwork_name (Name of the artwork) — varchar(255) — NOT NULL
  • type (Type of the artwork) — varchar(255) — NOT NULL — e.g. Oil on Canvas
  • open_date (Date when the artwork will be available) — datetime — NOT NULL
  • year (Year of the artwork) — varchar(255) — NOT NULL — Year, Country
  • amount (Left amount of the artwork) — int(11) — number : amount of artworks, null : inf
  • lengthX (Horizontal length of the artwork) — decimal(7,1)
  • lengthY (Vertical length of the artwork) — decimal(7,1)
  • lengthZ (Height of the artwork) — decimal(7,1)
  • size (Field) — int(1) — NOT NULL
  • font_color (Color of font used for the artwork page) — varchar(36) — NOT NULL
  • artwork_class (Class of artwork) — int(1) — NOT NULL — 0 : Only One, 1 : Edition, 2 : Order-made
  • sell_class (Selling status of the artwork) — int(1) — NOT NULL — 0 : Unavailable, 1 : Available, 2 : Preparing
  • edition_number (Total number of editions) — int(11) — Only if the artwork is 'edition', null if it is not edition
  • current_edition_number (Field2) — int(11)
  • certificated (Is the artwork certificated) — bit(1) — NOT NULL
  • in_resell (Is the artwork in resell) — bit(1) — NOT NULL
  • deleted (Has the artwork been deleted) — bit(1) — NOT NULL

artwork_form (Untitled8)

  • id (Key) — int(11) — Primary key — NOT NULL
  • artwork_id (Page ID of the artwork) — varchar(255) — Foreign key → artwork.page_id — NOT NULL
  • paint (Field) — bit(1) — NOT NULL
  • photo (Field9) — bit(1) — NOT NULL
  • printing (Field10) — bit(1) — NOT NULL
  • furniture (Field7) — bit(1) — NOT NULL
  • objet (Field2) — bit(1) — NOT NULL
  • accessory (Field4) — bit(1) — NOT NULL
  • goods (Field6) — bit(1) — NOT NULL
  • etc (Field8) — bit(1) — NOT NULL

artwork_keyword (Untitled12)

  • id (Key) — int(11) — Primary key — NOT NULL
  • artwork_id (Key2) — varchar(255) — Foreign key → artwork.page_id — NOT NULL
  • keyword_0 (Field) — varchar(36)
  • keyword_1 (Field2) — varchar(36)
  • keyword_2 (Field3) — varchar(36)
  • keyword_3 (Field4) — varchar(36)
  • keyword_4 (Field5) — varchar(36)
  • keyword_5 (Field6) — varchar(36)
  • keyword_6 (Field7) — varchar(36)
  • keyword_7 (Field8) — varchar(36)
  • keyword_8 (Field9) — varchar(36)
  • keyword_9 (Field10) — varchar(36)

artwork_style (Untitled10)

  • id (Key) — int(11) — Primary key — NOT NULL
  • artwork_id (Key2) — varchar(255) — Foreign key → artwork.page_id — NOT NULL
  • colorful (Field) — bit(1) — NOT NULL
  • monotonous (Field2) — bit(1) — NOT NULL
  • minimal (Field3) — bit(1) — NOT NULL
  • complicated (Field4) — bit(1) — NOT NULL
  • traditional (Field5) — bit(1) — NOT NULL
  • refined (Field6) — bit(1) — NOT NULL
  • realistic (Field7) — bit(1) — NOT NULL
  • abstractive (Field8) — bit(1) — NOT NULL
  • etc (Field9) — bit(1) — NOT NULL

artwork_subject (Untitled9)

  • id (Key) — int(11) — Primary key — NOT NULL
  • artwork_id (Key2) — varchar(255) — Foreign key → artwork.page_id — NOT NULL
  • person (Field) — bit(1) — NOT NULL
  • animal (Field2) — bit(1) — NOT NULL
  • fictional_character (Field3) — bit(1) — NOT NULL
  • still_life (Field15) — bit(1) — NOT NULL
  • scenery (Field4) — bit(1) — NOT NULL
  • abstract (Field5) — bit(1) — NOT NULL
  • watchword (Field6) — bit(1) — NOT NULL
  • event (Field14) — bit(1) — NOT NULL
  • metal (Field7) — bit(1) — NOT NULL
  • wood (Field8) — bit(1) — NOT NULL
  • masonry (Field9) — bit(1) — NOT NULL
  • ceramic (Field10) — bit(1) — NOT NULL
  • glass (Field11) — bit(1) — NOT NULL
  • paper_fabric (Field12) — bit(1) — NOT NULL
  • etc (Field13) — bit(1) — NOT NULL

blog (Untitled15)

  • id (Key) — varchar(255) — Primary key — NOT NULL
  • artist_page_id (Key2) — varchar(255) — Foreign key → artist_page.page_id — NOT NULL — 100000000 ~ MAX(UNSIGNED INT)
  • artist_id (User ID) — int(11) — Foreign key → artist_page.artist_id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
  • pinned_reply_id (Key3) — int(11) — Foreign key → reply.id
  • create_ip (Field) — varchar(36) — NOT NULL
  • last_update_ip (Field2) — varchar(36) — NOT NULL
  • last_access_ip (Field3) — varchar(36) — NOT NULL
  • create_date (Field4) — datetime — NOT NULL
  • update_date (Field5) — datetime — NOT NULL
  • delete_date (Field6) — datetime
  • last_access_date (Field7) — datetime — NOT NULL
  • like_count (Field8) — int(11) — NOT NULL
  • view_count (Field9) — int(11) — NOT NULL
  • share_count (Field10) — int(11) — NOT NULL
  • body (Field11) — longtext — NOT NULL
  • deleted (Field12) — bit(1) — NOT NULL

bookmark_artwork (CopyOfUntitled5)

  • user_id (User ID) — int(11) — Foreign key → user_page.user_id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
  • artwork_id (Key2) — varchar(255) — Foreign key → artwork.page_id — NOT NULL
  • create_date (Field) — datetime — NOT NULL

confirm_email (Untitled3)

  • id (Key) — int(11) — Primary key — NOT NULL
  • user_id (User ID) — int(11) — Foreign key → user.id — NOT NULL
  • expire_date (Date when the email verification expired) — datetime — NOT NULL
  • email (Email) — varchar(36) — NOT NULL
  • provider (SNS who provided the email) — varchar(36) — none : null, naver, kakao
  • salt (Salt for password) — varchar(255) — NOT NULL — Randomly generated

follow_artist (CopyOfUntitled6)

  • user_id (User ID) — int(11) — Foreign key → user_page.user_id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
  • artist_id (User ID2) — int(11) — Foreign key → artist_page.artist_id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
  • create_date (Date when following has been confirmed) — datetime — NOT NULL

follow_user (Untitled6)

  • user_id (User ID2) — int(11) — Foreign key → user_page.user_id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
  • follower_id (User ID) — int(11) — Foreign key → user_page.user_id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
  • create_date (Date when following has been confirmed) — datetime — NOT NULL

like_artwork (Untitled5)

  • user_id (User ID) — int(11) — Foreign key → user_page.user_id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
  • artwork_id (Key2) — varchar(255) — Foreign key → artwork.page_id — NOT NULL
  • create_date (Field) — datetime — NOT NULL

like_blog (Untitled16)

  • user_id (User ID) — int(11) — Foreign key → user_page.user_id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
  • blog_id (Key) — varchar(255) — Foreign key → blog.id — NOT NULL
  • create_date (Field) — datetime — NOT NULL

like_reply (Untitled14)

  • user_id (User ID) — int(11) — Foreign key → user_page.user_id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
  • reply_id (Key2) — int(11) — Foreign key → reply.id — NOT NULL
  • create_date (Field) — datetime — NOT NULL

log_in_user (Untitled)

  • id (Key) — int(11) — Primary key — NOT NULL
  • user_id (User ID) — int(11) — Foreign key → user.id — NOT NULL
  • log_in_date (Date when user account has logged in) — datetime — NOT NULL
  • remote_addr (Remote address IP from client) — varchar(36) — NOT NULL

oauth_token (Untitled2)

  • id (Key) — int(11) — Primary key — NOT NULL
  • user_id (User ID) — int(11) — Foreign key → user.id — NOT NULL
  • access_token (Access token from SNS oauth service) — varchar(255) — NOT NULL
  • provider (SNS who provided the token) — varchar(36) — NOT NULL — naver, kakao

person (Personal Information)

  • id (ID for person) — int(11) — Primary key — NOT NULL
  • create_date (Date when information is created) — datetime — NOT NULL
  • fullname (Full name of the person) — varchar(36) — NOT NULL
  • birthyear (Interval that birth year included) — varchar(36) — NOT NULL
  • birthdate (Date of birth (without year)) — varchar(36) — NOT NULL
  • gender (Gender (M: 0, F: 1)) — bit(1) — NOT NULL
  • phone (Phone number) — varchar(36) — NOT NULL
  • update_date (Last date when information is updated) — datetime — NOT NULL

reply (Untitled11)

  • id (Key) — int(11) — Primary key — NOT NULL
  • artwork_id (Key3) — varchar(255) — Foreign key → artwork.page_id
  • blog_id (Key5) — varchar(255) — Foreign key → blog.id
  • user_id (User ID) — int(11) — Foreign key → user_page.user_id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
  • user_page_id (Key4) — varchar(255) — Foreign key → user_page.page_id — NOT NULL — 100000000 ~ MAX(UNSIGNED INT)
  • parent_id (Key2) — int(11) — Foreign key → reply.id
  • create_ip (Field) — varchar(36) — NOT NULL
  • last_update_ip (Field2) — varchar(36) — NOT NULL
  • create_date (Field3) — datetime — NOT NULL
  • update_date (Field4) — datetime — NOT NULL
  • delete_date (Field5) — datetime
  • like_count (Field6) — int(11) — NOT NULL
  • body (Field7) — longtext — NOT NULL
  • artist_liked (Field8) — bit(1) — NOT NULL
  • deleted (Field9) — bit(1) — NOT NULL

user (Customer Information)

  • id (User ID) — int(11) — Primary key — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
  • person_id (ID for person) — int(11) — Foreign key → person.id — NOT NULL
  • account_expired (Has the account expired) — bit(1) — NOT NULL
  • account_locked (Has the account locked) — bit(1) — NOT NULL
  • create_ip (IP who created the user account) — varchar(36) — NOT NULL
  • last_access_ip (Last remote address IP for user account) — varchar(36) — NOT NULL
  • create_date (Date when the account is created) — datetime — NOT NULL
  • access_date (Date when last access has been made) — datetime — NOT NULL
  • password_change_date (Last date when password has been changed) — datetime
  • withdraw_date (Date when the account is withdrawn) — datetime
  • password (Password for user account) — varchar(255) — NOT NULL — Hashed
  • password_expired (Has the password expired) — bit(1) — NOT NULL — Expired after 6 months
  • withdrawn (Has the user account withdrawn) — bit(1) — NOT NULL

user_page (Untitled4)

  • page_id (Key) — varchar(255) — Primary key — NOT NULL — 100000000 ~ MAX(UNSIGNED INT)
  • user_id (User ID) — int(11) — Foreign key → user.id — NOT NULL — 10000 ~ MAX (UNSIGNED INT)
  • username (Customer's name) — varchar(36) — NOT NULL — Duplicate accepted
  • nickname (Nickname) — varchar(36) — NOT NULL — Randomly created, Duplicate not accepted
  • bio (Biography) — varchar(255) — NOT NULL
  • following_user_number (Number of users whom the user follows) — int(11) — NOT NULL
  • following_artist_number (Number of artists whom the user follows) — int(11) — NOT NULL
  • follower_number (Number of followers) — int(11) — NOT NULL
  • favorite_artist_page_id_0 (Key2) — varchar(255) — Foreign key → artist_page.page_id — 100000000 ~ MAX(UNSIGNED INT)
  • favorite_artist_page_id_1 (Key3) — varchar(255) — Foreign key → artist_page.page_id — 100000000 ~ MAX(UNSIGNED INT)
  • favorite_artist_page_id_2 (Key4) — varchar(255) — Foreign key → artist_page.page_id — 100000000 ~ MAX(UNSIGNED INT)