O!taku
Tables (10)
User
- Key (user_id) — int unsigned — Primary key — NOT NULL
- 이메일 (email) — varchar(50)
- 이름 (name) — varchar(50)
- 역할 (Role) — varchar(10)
- 상태 (status) — varchar(7)
- 생성일자 (created_date) — timestamp
authentication
- Key (authentication_id) — int unsigned — Primary key — NOT NULL
- Key (user_id) — int unsigned — Foreign key → User.Key — NOT NULL
- Key (event_id) — int unsigned — Foreign key → event.Key — NOT NULL
- 트위터 닉네임 (twitter_nickname) — varchar(50)
- 트위터 아이디 (twitter_id) — varchar(30)
- 상태 (status) — varchar(10)
- 생성일자 (created_date) — timestamp
event
- Key (event_id) — int unsigned — Primary key — NOT NULL
- Key (user_id) — int unsigned — Foreign key → User.Key — NOT NULL
- Key (subject_id) — int unsigned — Foreign key → subject.Key — NOT NULL
- 이름 (name) — varchar(50)
- 주소 (address) — varchar(100)
- 입장 코드 (code) — varchar(4)
- 대표 이미지 (featured_image) — varchar(100)
- 설명 (description) — varchar(500)
- 공개여부 (is_public) — boolean
- 트위터 닉네임 (nickname) — varchar(20)
- 트위터 아이디 (twitter_id) — varchar(30)
- 특전 이미지 (perks_image) — varchar(100)
- 개장일 (opened_date) — timestamp
- 폐장일 (closed_date) — timestamp
- 상태 (status) — varchar(20)
- 생성일자 (created_date) — timestamp
event_log
- Key (event_log_id) — int unsigned — Primary key — NOT NULL
- Key (user_id) — int unsigned — Foreign key → User.Key — NOT NULL
- Key (event_id) — int unsigned — Foreign key → event.Key — NOT NULL
- 상태 (status) — varchar(10)
- 생성일자 (created_date) — timestamp
host_inspection
- Key (host_inspection_id) — int unsigned — Primary key — NOT NULL
- Key (user_id) — int unsigned — Foreign key → User.Key — NOT NULL
- 인증url (auth_url) — varchar(100)
- 생성일자 (created_date) — timestamp
- 수정일자 (modifed_date) — timestamp
- 상태 (status) — varchar(10)
report
- Key (report_id) — int unsigned — Primary key — NOT NULL
- Key (event_id) — int unsigned — Foreign key → event.Key — NOT NULL
- Field (status) — varchar(10)
- Field (created_date) — timestamp
subject
- Key (subject_id) — int unsigned — Primary key — NOT NULL
- 카테고리 (category) — varchar(20)
- 이름 (name) — varchar(50)
support
- Key (support_id) — int unsigned — Primary key — NOT NULL
- Key (event_id) — int unsigned — Foreign key → event.Key — NOT NULL
- 목표 금액 (target_amount) — int unsigned
- 현재 금액 (current_amount) — int unsigned
- 계좌 번호 (account_address) — varchar(50)
- 예금주 (account_holder) — varchar(10)
- 상태 (status) — varchar(20)
support_log
- Key (support_log_id) — int unsigned — Primary key — NOT NULL
- Key (supporter_id) — int unsigned — Foreign key → User.Key — NOT NULL
- 인증url (auth_url) — varchar(100)
- 후원 금액 (support_amount) — int unsigned
- 상태 (status) — varchar(10)
- 생성일자 (created_date) — timestamp
- Key (support_id) — int unsigned — Foreign key → support.Key — NOT NULL
wish_list
- Key (wish_list_id) — int unsigned — Primary key — NOT NULL
- Key (user_id) — int unsigned — Foreign key → User.Key — NOT NULL
- Key (event_id) — int unsigned — Foreign key → event.Key — NOT NULL
- 상태 (status) — varchar(10)
- 생성일자 (created_date) — timestamp