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