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)
유저 (User)
- Key — 기본 키 — NOT NULL
- 파일Url (Field)
주문서-상품 (Untitled3)
- Key — 외래 키 → 주문서.Key — NOT NULL
- Key (Key2) — 외래 키 → 상품.Key — NOT NULL
파일 (File)
- 파일 기본키 (fileSeq) — 기본 키 — NOT NULL
- 파일URL (file_url)
- Field