mb

테이블 (14)

channel_management

  • id — BIGINT — NOT NULL
  • channel_name — VARCHAR(255)
  • account_list — VARCHAR(255)
  • keyword_list — VARCHAR(255)

exchange_notice

  • id — BIGINT — NOT NULL
  • notice_site_name — VARCHAR(255)
  • notice_title — VARCHAR(255)
  • notice_link — VARCHAR(255)
  • notice_publication_date — DATE
  • keywords — VARCHAR(255)
  • image_link — VARCHAR(255)

follow_management

  • id — BIGINT — NOT NULL
  • follower_account — VARCHAR(255)
  • followed_account — VARCHAR(255)
  • follow_date — DATE

keyword_management

  • id — BIGINT — NOT NULL
  • keyword — VARCHAR(255)

member_management

  • id — BIGINT — NOT NULL
  • member_username — VARCHAR(255)
  • role — VARCHAR(255)

modification_log

  • id — BIGINT — NOT NULL
  • modification_date — DATE
  • modified_by — VARCHAR(255)
  • modification_description — VARCHAR(255)

news

  • id — BIGINT — NOT NULL
  • site_name — VARCHAR(255)
  • news_title — VARCHAR(255)
  • news_link — VARCHAR(255)
  • news_publication_date — DATE
  • keywords — VARCHAR(255)
  • image_link — VARCHAR(255)

tweet

  • id — BIGINT — NOT NULL
  • tweet_content — VARCHAR(255)
  • account — VARCHAR(255)
  • publication_date — DATE
  • profile_image — VARCHAR(255)

user

  • id — BIGINT — NOT NULL
  • username — VARCHAR(255)
  • password — VARCHAR(255)
  • role — VARCHAR(255)

상품 (Untitled2)

  • Key — 기본 키 — NOT NULL

유저 (User)

  • Key — 기본 키 — NOT NULL
  • 파일Url (Field)

주문서 (Untitled)

  • Key — 기본 키 — NOT NULL

주문서-상품 (Untitled3)

  • Key — 외래 키 → 주문서.Key — NOT NULL
  • Key (Key2) — 외래 키 → 상품.Key — NOT NULL

파일 (File)

  • 파일 기본키 (fileSeq) — 기본 키 — NOT NULL
  • 파일URL (file_url)
  • Field