mogatshoo

Tables (8)

fortune

  • fortune_id — INT
  • fortune_create — TIMESTAMP
  • fortune_update — TIMESTAMP
  • fortune_content — TEXT — NOT NULL
  • fortune_item — VARCHAR(255)
  • member_id — INT — NOT NULL

member

  • member_id — INT
  • member_birth — DATE
  • member_create — TIMESTAMP
  • member_update — TIMESTAMP
  • member_address1 — VARCHAR(255)
  • member_address2 — VARCHAR(255)
  • member_email — VARCHAR(100) — NOT NULL
  • member_gender — CHAR(1)
  • member_info_check — BOOLEAN
  • member_name — VARCHAR(50) — NOT NULL
  • member_nick_name — VARCHAR(50)
  • member_pwd — VARCHAR(255) — NOT NULL
  • member_tel — VARCHAR(20)
  • member_zipcode — VARCHAR(10)
  • provider — VARCHAR(50)
  • provider_id — VARCHAR(100)
  • role — VARCHAR(20)

picture

  • picture_id — INT
  • member_id — INT — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • hair_picture — VARCHAR(255) — NOT NULL

point

  • member_id — INT
  • point — INT — NOT NULL
  • point_update — TIMESTAMP

point_history

  • point_history_id — INT
  • change_point — INT — NOT NULL
  • point_create — TIMESTAMP
  • member_id — INT — NOT NULL
  • reason — VARCHAR(255)
  • type — VARCHAR(50)

question

  • serial_number — INT
  • created_at — TIMESTAMP
  • is_public — BOOLEAN
  • option1 — VARCHAR(255) — NOT NULL
  • option2 — VARCHAR(255) — NOT NULL
  • option3 — VARCHAR(255)
  • option4 — VARCHAR(255)
  • question — TEXT — NOT NULL

stage

  • member_id — INT
  • create_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • hair_stage — INT — NOT NULL

voting

  • id — INT
  • selected_option — INT — NOT NULL
  • created_at — TIMESTAMP
  • serial_number — INT — NOT NULL
  • voted_id — INT
  • voter_id — INT — NOT NULL