ERD_1_ver02
Tables (10)
comment
- comment_seq — INT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- modify_time — TIMESTAMP — NOT NULL
- create_time — TIMESTAMP — NOT NULL
- feed_seq — INT — Foreign key → feed.feed_seq
- member_seq — INT — Foreign key → member.member_seq — NOT NULL
connect
- connect_seq — INT — Primary key — NOT NULL
- create_time — TIMESTAMP — NOT NULL
- follower — INT — Foreign key → member.member_seq — NOT NULL
- following — INT — Foreign key → member.member_seq — NOT NULL
feed
- feed_seq — INT — Primary key — NOT NULL
- member_seq — INT — Foreign key → member.member_seq
- content — TEXT
- post — VARCHAR(255)
- like — INT — NOT NULL
- create_time — TIMESTAMP — NOT NULL
- modify_time — TIMESTAMP — NOT NULL
heart (Untitled)
- heart_seq (hearat_seq) — INT — Primary key — NOT NULL
- member_seq — INT — Foreign key → member.member_seq — NOT NULL
- feed_seq — INT — Foreign key → feed.feed_seq — NOT NULL
machine
- machine_seq — INT — Primary key — NOT NULL
- recent_time — TIMESTAMP — NOT NULL
- create_time — TIMESTAMP — NOT NULL
- loc_seq — INT — Foreign key → machine_location.loc_seq — NOT NULL
machine_data
- machine_data_seq — INT — Primary key — NOT NULL
- photo — VARCHAR(255) — NOT NULL
- post — VARCHAR(255) — NOT NULL
- video — VARCHAR(255)
- voice — VARCHAR(255)
- create_time — TIMESTAMP — NOT NULL
- machine_seq — INT — Foreign key → machine.machine_seq — NOT NULL
machine_location
- loc_seq — INT — Primary key — NOT NULL
- city — VARCHAR(63) — NOT NULL
- name — VARCHAR(63) — NOT NULL
member
- member_seq — INT — Primary key — NOT NULL
- name — VARCHAR(45) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(45) — NOT NULL
- addr_base — VARCHAR(255)
- addr_spec — VARCHAR(255)
- member_profile — VARCHAR(255)
- member_state — VARCHAR(255)
- create_time — TIMESTAMP — NOT NULL
- modify_time — TIMESTAMP — NOT NULL
- is_admin — CHAR(1) — NOT NULL
notice
- notice_seq — INT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- create_time — TIMESTAMP — NOT NULL
- create_seq — INT — Foreign key → member.member_seq
- modify_time — TIMESTAMP — NOT NULL
- modify_seq — INT — NOT NULL
- hit — INT — NOT NULL
store
- store_seq — INT — Primary key — NOT NULL
- photo — VARCHAR(255) — NOT NULL
- video — VARCHAR(255)
- post — VARCHAR(255) — NOT NULL
- voice — VARCHAR(255)
- create_time — TIMESTAMP — NOT NULL
- create_seq — INT — Foreign key → member.member_seq — NOT NULL
- recent_time — TIMESTAMP — NOT NULL
- recent_seq — INT — NOT NULL