PJT1 - 1
Tables (10)
feed
- feed_id — INT — Primary key — NOT NULL — member과 매핑하기 위한 도구
- content — TEXT
- picture — BLOB
- like — INT
- create — DATETIME — NOT NULL
- modify — DATETIME — NOT NULL
feed_comment
- feed_id — INT — Foreign key → feed.feed_id — NOT NULL — member과 매핑하기 위한 도구
- Key — Foreign key → member.member_seq — NOT NULL
- content — TEXT
- modify_date — DATETIME — NOT NULL
- create_date — DATETIME
follow
- Key — Foreign key → member.member_seq — NOT NULL
- Key (Key2) — Foreign key → member.member_seq — NOT NULL
machine
- obj_id — INT — Primary key — NOT NULL
- picture — BLOB — NOT NULL
- post — BLOB — NOT NULL
- video — BLOB — NOT NULL
- create_date — DATETIME — NOT NULL
member
- member_seq — int — Primary key — NOT NULL
- id — VARCHAR(20)
- password — VARCHAR(20) — NOT NULL
- name — VARCHAR(15) — NOT NULL
- nickname — VARCHAR(15) — NOT NULL
- email — VARCHAR(50) — NOT NULL
- phone — VARCHAR(15) — NOT NULL
- address_base — VARCHAR(255)
- address_spec — VARCHAR(255)
- memo — TEXT
member-feed
- id (id2) — INT — Foreign key → feed.feed_id — NOT NULL — member과 매핑하기 위한 도구
- Key — Foreign key → member.member_seq — NOT NULL
mypage
- Key — Foreign key → member.member_seq — NOT NULL
- Field
notice
- id — INT — Primary key — NOT NULL
- title — varchar(63)
- content — text
- picture — BLOB
- create_date — DATETIME
- modify_date — DATETIME — NOT NULL
- hit — INT
- Key — Foreign key → member.member_seq — NOT NULL
notice_comment (notice_coment)
- id (id2) — INT — Foreign key → notice.id — NOT NULL
- Key — Foreign key → member.member_seq — NOT NULL
- content — TEXT
- modify_date — DATETIME — NOT NULL
- create_date — DATETIME
record
- Key — Foreign key → member.member_seq — NOT NULL
- picture — BLOB — NOT NULL
- post — BLOB — NOT NULL
- video — BLOB — NOT NULL
- create_date — DATETIME — NOT NULL
- download_data — DATETIME