atumari
Tables (11)
community
- cmty_no — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- attach — VARCHAR(255)
- reg_date — DATETIME — NOT NULL
- update_date — DATETIME
- hit — INT — NOT NULL
community_comments
- comment_no — BIGINT — Primary key — NOT NULL
- cmty_no — BIGINT — NOT NULL
- member_id — BIGINT — NOT NULL
- parent_no — BIGINT — Foreign key → community_comments.comment_no
- content — TEXT — NOT NULL
- reg_date — TIMESTAMP — NOT NULL
- update_date — TIMESTAMP
- is_deleted — INT — NOT NULL
community_files
- file_no — BIGINT — Primary key — NOT NULL
- cmty_no — BIGINT — Foreign key — NOT NULL
- original_file_name — VARCHAR(255) — NOT NULL
- save_file_name — VARCHAR(255) — NOT NULL
festival
- festival_no — INT — Primary key — NOT NULL
- festival_id — INT — NOT NULL
- festival_name — VARCHAR(200) — NOT NULL
- summary — TEXT
- start_datetime — DATETIME
- end_datetime — DATETIME
- venue_name — VARCHAR(300)
- venue_address — VARCHAR(300)
- access_info — TEXT
- image_url — TEXT
- organizer — VARCHAR(300)
- price_free — BOOLEAN
- price_text — VARCHAR(500)
- external_url — TEXT
- image_source — TEXT
- prefecture_no — INT — Foreign key → prefecture.prefecture_no
- season — VARCHAR(20)
inquiry
- inquiry_no — INT — Primary key — NOT NULL
- member_id — INT — Foreign key → member.id
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- email — VARCHAR(255)
- status — VARCHAR(20) — NOT NULL
- is_public — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- answer_content — TEXT
- answered_at — DATETIME
- password — VARCHAR(255)
inquiry_file
- file_no — INT — Primary key — NOT NULL
- inquiry_no — INT — Foreign key → inquiry.inquiry_no — NOT NULL
- original_file_name — VARCHAR(255) — NOT NULL
- stored_file_name — VARCHAR(255) — NOT NULL
member
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255)
- tel — VARCHAR(100)
- reg_date — TIMESTAMP — NOT NULL
- modify_date — TIMESTAMP
- exit_date — TIMESTAMP
- rk — VARCHAR(100)
- filepath — VARCHAR(5000)
member_auth
- auth_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- password — VARCHAR(255)
- provider — VARCHAR(20) — NOT NULL
- provider_id — VARCHAR(255)
notice
- notice_no — INT — Primary key — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — LONGTEXT — NOT NULL
- author_id — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
notice_file
- file_no — INT — Primary key — NOT NULL
- notice_no — INT — Foreign key → notice.notice_no — NOT NULL
- original_file_name — VARCHAR(255) — NOT NULL
- stored_file_name — VARCHAR(255) — NOT NULL
prefecture
- prefecture_no — INT — Primary key — NOT NULL
- prefecture_name — VARCHAR(100) — NOT NULL
- region_name — VARCHAR(100) — NOT NULL