ss
Tables (15)
faq
- id — INT — Primary key — NOT NULL
- title — VARCHAR(128) — NOT NULL
- content — TEXT — NOT NULL
favorite_destination
- id — int — Primary key — NOT NULL
- favorite_order — TINYINT — NOT NULL
- u_id — int — NOT NULL
- place_name — VARCHAR(32) — NOT NULL
- address — VARCHAR(64) — NOT NULL
- predict_time — TIME
feedback
- id — INT — Primary key — NOT NULL
- u_id — INT — NOT NULL
- reg_date — DATETIME — NOT NULL
- image_location — VARCHAR(256)
inefficiency_section
- id — INT — Primary key — NOT NULL
- u_id — INT — NOT NULL
- longitude — FLOAT — NOT NULL
- latitude — FLOAT — NOT NULL
- address — VARCHAR(256) — NOT NULL
- reg_date — DATETIME — NOT NULL
notice
- id — INT — Primary key — NOT NULL
- title — VARCHAR(128) — NOT NULL
- content — TEXT — NOT NULL
- register_date — DATETIME — NOT NULL
notification
- id — INT — Primary key — NOT NULL
- u_id — INT — NOT NULL
- b_id — INT — NOT NULL
- category — TINYINT
- is_read — BOOLEAN
- content — VARCHAR(1024) — NOT NULL
- reg_date — DATETIME
qna_answer
- id — INT — Primary key — NOT NULL
- q_id — INT — NOT NULL
- content — TEXT — NOT NULL
- image_location — VARCHAR(256)
- reg_date — DATETIME
qna_question
- id — INT — Primary key — NOT NULL
- u_id — INT — NOT NULL
- category — TINYINT
- title — VARCHAR(64) — NOT NULL
- content — TEXT — NOT NULL
- is_answer — BOOLEAN
- image_location — VARCHAR(256)
- reg_date — DATETIME
schedule
- id — INT — Primary key — NOT NULL
- u_id — INT — NOT NULL
- origin — VARCHAR(256) — NOT NULL
- destination — VARCHAR(256) — NOT NULL
- arrival_time — DATETIME — NOT NULL
- content — VARCHAR(512)
- alarm — VARCHAR(20)
- navi — VARCHAR(20)
- parkinglot — VARCHAR(256)
- reg_date — DATETIME
- take — VARCHAR(128)
- partner — VARCHAR(64)
- partner_m — VARCHAR(256)
- predict_start_time — TIME
schedule_partner
- id — INT — NOT NULL
- partner — VARCHAR(32) — NOT NULL
schedule_state
- id — INT — Primary key — NOT NULL
- s_id — INT — NOT NULL
- longitude — FLOAT — NOT NULL
- latitude — FLOAT — NOT NULL
- schstat — VARCHAR(3)
- latestat — BOOLEAN
- message — BOOLEAN
- parking_time — TIME
schedule_take
- id — INT — NOT NULL
- category — TINYINT
- time — TIME
user
- id — INT — Primary key — NOT NULL
- email — VARCHAR(32) — NOT NULL
- password — VARCHAR(128) — NOT NULL
- role — VARCHAR(16) — NOT NULL
- nickname — VARCHAR(256) — NOT NULL
- phone_num — VARCHAR(24) — NOT NULL
- sex — CHAR(1) — NOT NULL
- birth — CHAR(8) — NOT NULL
- address — VARCHAR(64) — NOT NULL
- n_e_notification — BOOLEAN
- kind — VARCHAR(24)
- place — INT
- bad_road — INT
- feedback — VARCHAR(256)
- last_login — DATETIME
- reg_date — DATETIME — NOT NULL
user_marketing
- id — int — Primary key — NOT NULL
- u_id — int — NOT NULL
- agree — BOOLEAN — NOT NULL
- email — BOOLEAN — NOT NULL
- sms — BOOLEAN — NOT NULL
- push — BOOLEAN — NOT NULL
user_schedule_notification
- id — INT — NOT NULL
- u_id — INT — NOT NULL
- agree — BOOLEAN
- times — TINYINT
- INDEX — nix_schedule_notification_id