ㅁㄴㅇㄹㄴㅁㅇㄹ
Tables (8)
Follower
- follower_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL — ID
- company_id — BIGINT — Foreign key → company.company_id — NOT NULL
- follower_member — BIGINT
board_like
- feed_like_id — BIGINT — Primary key — NOT NULL
- feed_id — BIGINT — Foreign key → feed.feed_id — NOT NULL
- user_id — BIGINT — Foreign key → feed.user_id — NOT NULL — ID
- company_id — BIGINT — Foreign key → feed.company_id — NOT NULL
comment
- comment_id — BIGINT — Primary key — NOT NULL
- feed_id — BIGINT — Foreign key → feed.feed_id — NOT NULL
- feed_user_id — BIGINT — Foreign key → feed.user_id — NOT NULL — ID
- company_id — BIGINT — Foreign key → feed.company_id — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL — ID
- group — INT
- depth — INT
- parent — INT
- content — VARCHAR(50)
- created_datetime — DATETIME
comment_like
- comment_like_id — BIGINT — Primary key — NOT NULL
- comment_id — BIGINT — Foreign key → comment.comment_id — NOT NULL
- user_id — BIGINT — Foreign key → comment.user_id — NOT NULL — ID
- company_id — BIGINT — Foreign key → comment.company_id — NOT NULL
company
- company_id — BIGINT — Primary key — NOT NULL
- company_email — VARCHAR(45)
- company_password — VARCHAR(45)
- company_name — VARCHAR(45)
- company_nickname — VARCHAR(45)
- company_tel — VARCHAR(20)
- company_address — VARCHAR(200)
- created_datetime — DATETIME
- modified_datetime — DATETIME
- approval — BOOLEAN
feed
- feed_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL — ID
- company_id — BIGINT — Foreign key → company.company_id — NOT NULL
- content — VARCHAR(1000)
- sunin — BOOLEAN
- created_datetime — DATETIME
- modified_datetime — DATETIME
hashtag
- hashtag_id — BIGINT — Primary key — NOT NULL
- feed_id — BIGINT — Foreign key → feed.feed_id — NOT NULL
- company_id — BIGINT — Foreign key → feed.company_id — NOT NULL
- hashtag — VARCHAR(45)
user
- user_id — BIGINT — Primary key — NOT NULL — ID
- user_email — VARCHAR(45)
- user_password — VARCHAR(45)
- user_name — VARCHAR(45)
- user_nickname — VARCHAR(45)
- user_tel — VARCHAR(20)
- user_address — VARCHAR(200)
- created_datetime — DATETIME
- modified_datetime — DATETIME