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